Difference between revisions of "Import Data"
Jump to navigation
Jump to search
(Created page with "= Overview = This import uses an XLS Spreadsheet to import all of the necessary data. It is recommended to import in the order displayed in this Wiki. = Customers = Column Fo...") |
|||
| Line 4: | Line 4: | ||
= Customers = | = Customers = | ||
Column Format: | Column Format: | ||
| − | Customer | + | #Customer |
| − | Telephone Number | + | #Telephone Number |
| − | Accounts Contact | + | #Accounts Contact |
| − | Customer Service Contact | + | #Customer Service Contact |
| − | Accounts Email Address | + | #Accounts Email Address |
| − | Customer Service Email Address | + | #Customer Service Email Address |
| − | Invoice Line 1 | + | #Invoice Line 1 |
| − | Invoice Line 2 | + | #Invoice Line 2 |
| − | Invoice Line 3 | + | #Invoice Line 3 |
| − | Invoice Line 4 | + | #Invoice Line 4 |
| − | Invoice Line 5 | + | #Invoice Line 5 |
| − | Delivery Line 1 | + | #Delivery Line 1 |
| − | Delivery Line 2 | + | #Delivery Line 2 |
| − | Delivery Line 3 | + | #Delivery Line 3 |
| − | Delivery Line 4 | + | #Delivery Line 4 |
| − | Delivery Line 5 | + | #Delivery Line 5 |
| − | VAT Number | + | #VAT Number |
= Machines = | = Machines = | ||
Column Format: | Column Format: | ||
| − | Machine ID Number | + | #Machine ID Number |
| − | Machine Specification | + | #Machine Specification |
| − | Serial Number | + | #Serial Number |
| − | Year of Manufacture | + | #Year of Manufacture |
| − | Machine Rate Per Hour | + | #Machine Rate Per Hour |
= Tools = | = Tools = | ||
Column Format: | Column Format: | ||
| − | Tool Number | + | #Tool Number |
| − | Rack Location | + | #Rack Location |
| − | Available Status | + | #Available Status |
= Stock Category Codes = | = Stock Category Codes = | ||
Column Format: | Column Format: | ||
| − | Code ID | + | #Code ID |
| − | Description | + | #Description |
= Finished Goods = | = Finished Goods = | ||
Column Format: | Column Format: | ||
| − | Customer | + | #Customer |
| − | Own SKU | + | #Own SKU |
| − | Customer SKU | + | #Customer SKU |
| − | Part Description | + | #Part Description |
| − | Colour | + | #Colour |
| − | Commodity Code | + | #Commodity Code |
| − | Box Quantity | + | #Box Quantity |
= Suppliers = | = Suppliers = | ||
Column Format: | Column Format: | ||
| − | Supplier Name | + | #Supplier Name |
| − | Telephone Number | + | #Telephone Number |
| − | Accounts Contact | + | #Accounts Contact |
| − | Customer Service Contact | + | #Customer Service Contact |
| − | Accounts Email Address | + | #Accounts Email Address |
| − | Customer Service Email Address | + | #Customer Service Email Address |
| − | Invoice Line 1 | + | #Invoice Line 1 |
| − | Invoice Line 2 | + | #Invoice Line 2 |
| − | Invoice Line 3 | + | #Invoice Line 3 |
| − | Invoice Line 4 | + | #Invoice Line 4 |
| − | Invoice Line 5 | + | #Invoice Line 5 |
| − | Delivery Line 1 (Not Used) | + | #Delivery Line 1 (Not Used) |
| − | Delivery Line 2 (Not Used) | + | #Delivery Line 2 (Not Used) |
| − | Delivery Line 3 (Not Used) | + | #Delivery Line 3 (Not Used) |
| − | Delivery Line 4 (Not Used) | + | #Delivery Line 4 (Not Used) |
| − | Delivery line 5 (Not Used) | + | #Delivery line 5 (Not Used) |
| − | VAT Number | + | #VAT Number |
= Supplier Data = | = Supplier Data = | ||
Column Format: | Column Format: | ||
| − | Supplier Name | + | #Supplier Name |
| − | Our SKU | + | #Our SKU |
| − | Supplier Description | + | #Supplier Description |
| − | Supplier Reference / SKU | + | #Supplier Reference / SKU |
| − | Minimum Order Quantity | + | #Minimum Order Quantity |
| − | Lead Time (Days) | + | #Lead Time (Days) |
| − | Price Per KG | + | #Price Per KG |
| − | Price Per Thousand | + | #Price Per Thousand |
| − | Price Each | + | #Price Each |
Revision as of 14:55, 14 February 2021
Contents
Overview
This import uses an XLS Spreadsheet to import all of the necessary data. It is recommended to import in the order displayed in this Wiki.
Customers
Column Format:
- Customer
- Telephone Number
- Accounts Contact
- Customer Service Contact
- Accounts Email Address
- Customer Service Email Address
- Invoice Line 1
- Invoice Line 2
- Invoice Line 3
- Invoice Line 4
- Invoice Line 5
- Delivery Line 1
- Delivery Line 2
- Delivery Line 3
- Delivery Line 4
- Delivery Line 5
- VAT Number
Machines
Column Format:
- Machine ID Number
- Machine Specification
- Serial Number
- Year of Manufacture
- Machine Rate Per Hour
Tools
Column Format:
- Tool Number
- Rack Location
- Available Status
Stock Category Codes
Column Format:
- Code ID
- Description
Finished Goods
Column Format:
- Customer
- Own SKU
- Customer SKU
- Part Description
- Colour
- Commodity Code
- Box Quantity
Suppliers
Column Format:
- Supplier Name
- Telephone Number
- Accounts Contact
- Customer Service Contact
- Accounts Email Address
- Customer Service Email Address
- Invoice Line 1
- Invoice Line 2
- Invoice Line 3
- Invoice Line 4
- Invoice Line 5
- Delivery Line 1 (Not Used)
- Delivery Line 2 (Not Used)
- Delivery Line 3 (Not Used)
- Delivery Line 4 (Not Used)
- Delivery line 5 (Not Used)
- VAT Number
Supplier Data
Column Format:
- Supplier Name
- Our SKU
- Supplier Description
- Supplier Reference / SKU
- Minimum Order Quantity
- Lead Time (Days)
- Price Per KG
- Price Per Thousand
- Price Each
