Import Data
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.
Step 1 - Upload File
The first step is to upload the Excel file. Supported files are XLS, XLSX and XLSM. Contact support for other file types.
Step 2 - Worksheet Options
Select Worksheet
Select the appropriate worksheet from the drop-down box.
Ignore the First Row
Tick this option if the worksheet has a header record. So the import will ignore the first line.
Select Import Type
Select the appropriate import type to import against.
Step 3 - Confirm Data
On Step 3 you will be presented with the data. Anything in green will be created, anything in blue will be updated, anything in red is an error and needs resolving before you are able to complete the import.
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
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
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
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
Finished Goods
- Column Format
- Customer
- Your Part Number / SKU
- Customer Part Number / SKU
- Part Description
- Colour
- Commodity Code
- Box Quantity
Bill of Material / Family Products
- Column Format
- Customer
- Your Part Number / SKU
- Customer Part Number / SKU
- Part Description
- Commodity Code
- Finished Component Colour
- Part Weight
- Material Stock Code
- Material Description
- Material Supplier Reference
- Material %
- Masterbatch Stock Code
- Masterbatch Description
- Masterbatch Supplier Reference
- Masterbatch %
- BOP Stock Code
- BOP Description
- BOP Supplier Reference
- BOP UOM
- BOP Stock Code
- BOP Description
- BOP Supplier Reference
- BOP UOM
- Bag Stock code
- Bag Description
- Bag Supplier Reference
- Bag UOM
- Bag Quantity
- Box Stock Code
- Box Description
- Box Supplier Reference
- Box UOM
- Box Quantity
- Preferred Machine 1
- Preferred Machine 2
- Preferred Machine 3
- Cavities
- Tool Number
- Labour Content
- Standard Cycle Time
- Set Up Time (hours)
- Scrap %
- Selling Price each
- Secondary Op Needed
- Comments