Page Comparison

Table of Contents

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))
1. Note ensure the list of materials is sorted longest at the top - then "Shiny Red" will be found before "Red"
2. 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)
1. may need to adjust Ml to ml etc after

...

General Information

Measures

supplier related

Pricing Related

Food Related

clothing

Warehouse related

SKU

Limit 20 Characters

packing factor

Number <=1
2 decimal places

supplier name item OR supplier name part

Text

costprice

Default buy price per SKU

serving per pack OR ServingPerPack

size

Name

Text
Mandatory Field

pack size

Whole Number

Supplier OR manufacturer

Search code for supplier

av cost

ingredients

sizeseq

description

Text

DimUnit

mm, inch, m

their part number OR supplier part number

sellprice

Default Sell price per SKU

certification OR lifestyle

gender

short description

Text

width

Brand

RRP

per SKU

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

Number of months

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

Text - max length 30

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

Buy/Sell?

Buy - Article is only bought but not sold

style group OR productgroup

Limit 30 characters

"Size" and "group" in column name

colour size group (same item in sizes and colour ranges)

assembly

JIT, Stock, Kit, Recipe

color

webdescription

html content
Example

No Format

nopanel	true

<ul style="line-height: 20.8px;">_x000D_
	<li>&nbsp; Poly/cotton/Spandex</li>_x000D_
	<li>&nbsp; Roll-up long-sleeve with 1-button tab</li>_x000D_
	<li>&nbsp; Double back yoke</li>_x000D_
	<li>&nbsp; Triple-needle stitching</li>_x000D_
	<li>&nbsp; 2 front pockets with flaps</li>_x000D_
	<li>&nbsp; Available in gray, white or black</li>_x000D_
	<li>&nbsp; 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

...

Versions Compared

Old Version 33

New Version 34

Key