Versions Compared

Old Version 38

changes.mady.by.user P Sawkins (Unlicensed)

Saved on

compared with

New Version Current

changes.mady.by.user Paul Sawkins

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

...

  1. Check your spreadsheet is in the layout attached (note column headings are important)
  2. Ensure all the following has been done already
    1. All the Article Categories in the spreadsheet have already been created in the system
    2. All suppliers have been created in the system - the supplier column contains the supplier code
    3. You have adhered to the field limit for all the fields being uploaded

Import to Test - before importing to live

To avoid a difficult process of removing the articles imported - first test the upload and the results you get in test.

...

Warning
titleOrder Optimisation Cache

Orders use an optimisation cache that updates automatically as data ages

Administrators can update the cache manually anytime from the sales order screen

Image Added

Soulfresh Global Pty Ltd 


Import to Test - before importing to live

To avoid a difficult process of removing the articles imported - first test the upload and the results you get in test.

Check some of the transactions you expect to make - sales orders, etc.

...

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:

  1. 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
  2. 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 relatedPricing RelatedFood RelatedclothingWarehouse 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

  1. Whole Number

Supplier OR manufacturer

  1. Search code for supplier

av cost

ingredients

sizeseq

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

  • Text

DimUnit

  1. mm, inch, m

their part number OR supplier part number

sellprice

  • Default Sell price per SKU

certification OR lifestyle

gender

short description

  • Text
widthBrand

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

  1. 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



eanmeasure

alt buy price

  • Buy price in special circumstances = eg drop ship if different.



Barcodemeasure 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

  • Limit 30 characters


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

  • JIT, Stock, Kit, Recipe


color

Cart Status

column name has Cart Status

new = new

top = top

featured = featured

none = hidden 




assembly

  • JIT, Stock, Kit, Recipe


Buy and Sell

Buy = Buy

Sell = Sell

Buy Sell = Buy and Sell

rest = None (none)




color





webdescription

  • html content
  • Example
No Format
nopaneltrue
<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

  1. Import/update article from spreadsheet: Case and order of words in column headings is not important.

    1. Cartons Per Layer, Article form, Selling / Shipping / Warranty (new):

      1. Column heading must contain all words ‘sell cartons per layer'.

    2. Layers Per Pallet, Article form, Selling / Shipping / Warranty (new):

      1. Column heading must contain all words 'sell layers per pallet'.

    3. Qty 20 foot, Article form, Supplier Shipping / Purchase Receipting (changed):

      1. Column heading must contain all words 'purchase units per layer'.

    4. Qty 40 foot, Article form, Supplier Shipping / Purchase Receipting (changed):

      1. Column heading must contain all words 'purchase layers per pallet'.







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 Packing Notes

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 

  1. SKU
  2. PackingNotes

Stock > Stock Articles > Drag XLS over the screen > Action > Import PackingNotes.xlsx - SKUs updates only to the article

All items should be imported correctly

  • If not copy the log and make corrections to the import file and import again

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 

  1. SKU
  2. Min
  3. 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

  • If not copy the log and make corrections to the import file and import again

Importing Packs as a single row - both carton and each at the same time

...

  1. SKU code in the system
  2. URL for the related image

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

...