Table of Contents
...
| Note |
|---|
Columns that do not match up with one of the import names will be ignored and the first line on the import result will be a list of the ignored columns Useful Google Sheet calculations: - Look for a material in the suppliers name (use named ranges) =INDEX(Materialresultlist,MATCH(TRUE,ISNUMBER(SEARCH(Materiallist,B2)),0))
- Note ensure the list of materials is sorted longest at the top - then "Shiny Red" will be found before "Red"
- Export from the item Profile for Material to find a list of possible values for that material
- If the supplier provides the name all in caps = Proper(a2)
- may need to adjust Ml to ml etc after
|
...
| General Information | Measures | supplier related | Pricing Related | Food Related | clothing | Warehouse related |
|---|
SKU | packing factor - Number <=1
- 2 decimal places
| supplier name item OR supplier name part | costprice - Default buy price per SKU
| serving per pack OR ServingPerPack | size |
|
Name | pack size - Whole Number
| Supplier OR manufacturer - Search code for supplier
| av cost Note - user must have Secure Features#CanSeeItemBuyPrice with qualifier > 0 in order to update Note - a journal will be created for the value of the change unless "allow unjournalled stock adjustments" is ticked in Stock Control Settings | ingredients | sizeseq |
|
description | DimUnit - mm, inch, m
| their part number OR supplier part number | sellprice - Default Sell price per SKU
| certification OR lifestyle | gender |
|
short description | width | Brand | RRP | Serving Size | fabric |
|
category - Bottom level product category - eg Fish / Fishbowls = Fishbowls
- Mandatory Field
| height | Range - Text - limit 50 characters
| inner buy price - Price break special type of "Inner" - buy price
| Claims | manuid |
|
pack size - Whole number
- Number of units in the SKU
| depth | Warranty Period | inner qty OR inner quantitiy - Price break special type of "Inner" - price break quantity.
- Whole Number
| NipServe | - yearSeasonId
|
|
UOM - Text describing the unit of measure - eg Carton of 50
- Limit 20 characters
| unit width |
| carton qty - Price break special type of "Carton" - price break quantity
- Whole Number
|
|
|
|
unit qty OR unit quantity - Each, Each/Bulk, Pack, Other
| unit depth |
| carton buy price - Price break special type of "Carton" - buy price
|
|
|
|
Colour | unit height |
| carton sell price - Price break special type of "Carton" - sell price
|
|
|
|
storage - donotstock
- chilled
- frozen
- controlled
| massunit |
| pallet qty OR pallet quantity - Price break special type of "Pallet" - price break quantity
- Whole Number
|
|
|
|
name pkg OR name package | netmass |
| pallet buy price - Price break special type of "Pallet" - buy price
|
|
|
|
Xref OR extref OR ext ref - example code in previous system
| grossmass |
| pallet sell price - Price break special type of "Pallet" - buy price
|
|
|
|
| ean | measure |
| alt buy price - Buy price in special circumstances = eg drop ship if different.
|
|
|
|
| Barcode | measure unit |
| gst - Ex - set Price-GST to ex-GST.
. |
|
|
|
| custom name | is Repairable y |
| Buy/Sell? - Buy - Article is only bought but not sold
|
|
|
|
style group OR productgroup |
|
| Packing Notes column name has pack and notes |
|
|
|
"Size" and "group" in column name - colour size group (same item in sizes and colour ranges)
|
|
|
|
|
|
|
assembly |
|
|
|
|
|
|
| color |
|
|
|
|
|
|
webdescription | No Format |
|---|
| <ul style="line-height: 20.8px;">_x000D_
<li> Poly/cotton/Spandex</li>_x000D_
<li> Roll-up long-sleeve with 1-button tab</li>_x000D_
<li> Double back yoke</li>_x000D_
<li> Triple-needle stitching</li>_x000D_
<li> 2 front pockets with flaps</li>_x000D_
<li> Available in gray, white or black</li>_x000D_
<li> Sizes S-2XL</li>_x000D_
</ul>_x000D_ |
|
|
|
|
|
|
|
| WebFeatures |
|
|
|
|
|
|
ANY SIMPLE PROFILE TYPE = *Profilename - eg - item profile type = Material
- Column is headed = *Material
- Values can only be those defined
- eg - item profile type = Glove Size
- Column is headed = *Glove Size
- Values can only be those defined
|
|
|
|
|
|
|
Carton dimensions and barcode | Code Block |
|---|
else if (col.Contains("depth") && col.Contains("carton")) iCartonDepth = i;
else if (col.Contains("width") && col.Contains("carton")) iCartonWidth = i;
else if (col.Contains("height") && col.Contains("carton")) iCartonHeight = i;
else if (col.Contains("barcode") && col.Contains("carton")) iCartonBarcode = i; |
|
|
|
|
|
|
|
eg item profile
Importing Stock Min / Max levels by warehouse
The stock Articles must exist in the system (will get error messages for all articles that do not exist) + Users Must have Secure Features#IsStockManager
Columns
- SKU
- Min
- Max
Admin > Stock > Warehouses > List (choose the warehouse> > Drag XLS over the warehouse > Action > Import items min/max to the warehouse
All items should be imported correctly
...