Versions Compared

Old Version 26

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

Saved on

compared with

New Version 27

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

Saved on

Key

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

Table of Contents

Table of Contents

...

To import Articles to the system - note you will need the Secure Feature "Is Stock Manager"

Drag the spreadsheet over the Stock Articles Screen

...

To import Articles to the system - note you will need a /wiki/spaces/SI/pages/33054890 with "Stock Manager" from Secure Features List and their impacts

  1. Navigate to "upload supplier Articles"
  2. Choose the supplier name (determines the spreadsheet expected layout and hence import routine to use)
  3. Drag the spreadsheet over the screen - choose load to server
  4. Action - Upload to supplier X
  5. Review the results

...

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

...

The stock Articles must exist in the system (will get error messages for all articles that do not exist) + Users Must be Administrators of the system

Columns 

  1. SKU
  2. Min
  3. Max

Warehouse screen > choose the warehouse > Drag XLS over the warehouse

...