Difference between revisions of "Import Data"
Jump to navigation
Jump to search
Line 66: | Line 66: | ||
;Column Format: | ;Column Format: | ||
#Customer | #Customer | ||
− | # | + | #Your Part Number / SKU |
− | #Customer Part Number | + | #Customer Part Number / SKU |
#Part Description | #Part Description | ||
#Commodity Code | #Commodity Code | ||
Line 110: | Line 110: | ||
#Secondary Op Needed | #Secondary Op Needed | ||
#Comments | #Comments | ||
+ | |||
+ | = 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 | ||
+ | #Comment | ||
= Suppliers = | = Suppliers = |
Revision as of 17:31, 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
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
- Own SKU
- Customer SKU
- Part Description
- Colour
- Commodity Code
- Box Quantity
Bill of Material 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
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
- Comment
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