Skip to content
English
Contact us
  • There are no suggestions because the search field is empty.

Stock Import

Stock Import - Schedule Job 

 

Skip First Line

  • Use this if the first line of the import has column names

Force Proper Case

  • This will capitalise the first character of each word

Filename to Import

  • This is filename only of the File to Import

Extra Directory Info

  • This is the directory from where to import from

Archive Directory

  • After the file is processed, it will be archived here

 

Notes

·         If the directory name is too large for the field, you can put some of the directory name in the File name field

o    These fields are concatenated to form the full path

·         Stores and suppliers that are not matched will be created

o    If no Store name is supplied, but store data is supplied (Cost or prices) then this data will be updated into ALL Stores

·         All fields do not have to be completed; in fact, simply the product name only (the first field) is all that is needed to successfully create imported products

Tips

  • There are various ways existing products will be matched; the order is as the match flag fields appear

  • The whole Product Group tree can be imported if required

    • This should be done prior to importing the products so the group names can be matched

    • Group names that are not matched will be added; if no Group names are specified, a group called Imported Products will be created

Sample File

Import Format Specification

 

FieldName

Mandatory

Format

Description & Notes

Accepted Inputs

A

VENUEID

 

Numeric

This is the VenueID of the store.

 

B

STOREID

 

Numeric

This is the StoreID where the Stock Record will be created

 

C

PRODUCT_NAME

 

AlphaNumeric

At least one of the fields from C, D, E, F, G must contain a value

 

D

PRODUCT_ID

 

Numeric

At least one of the fields from C, D, E, F, G must contain a value

 

E

PROD_NUMBER

 

AlphaNumeric

At least one of the fields from C, D, E, F, G must contain a value

 

F

EXPORTCODE1

 

AlphaNumeric

At least one of the fields from C, D, E, F, G must contain a value

 

G

BARCODE

 

AlphaNumeric

  • At least one of the fields from C, D, E, F, G must contain a value

  • Barcode Matches Product and Size

  • If no size match for barcode, use the base single unit size for that product

 

H

SIZENAME

 

AlphaNumeric

  • This is the size name. The import should match the product and size.

  • If no SizeName, use SizeNum.

  • If SizeName, SizeNum

 

I

SIZENUM

 

Numeric

  • the size number (1-10). The import should match the product and size.

  • Use SizeName fir

 

J

DESCRIPTION

 

AlphaNumeric

This is a description that will appear in the Stock Journal report Description field. This could be used to understand that the stock record was created by an import. If no value entered use the following Description: "Created by Stock Import"

 

K

MATCHON_PRODUCTNAME

 

Boolean

Default to Y if ProductName Field not empty

  • Default = True

  • 1=Yes; 2=No

  • Yes/No

  • Y/N

  • True/False, T/F

  • 1/0

L

MATCHON_PRODUCTID

 

Boolean

Default to Y if ProductID Field not empty

  • Default = True

  • 1=Yes; 2=No

  • Yes/No

  • Y/N

  • True/False, T/F

  • 1/0

M

MATCHON_PRODNUM

 

Boolean

Default to Y if PRODNUMBER Field not empty

  • Default = True

  • 1=Yes; 2=No

  • Yes/No

  • Y/N

  • True/False, T/F

  • 1/0

N

MATCHON_EXPORTCODE1

 

Boolean

Default to Y if ExportCode1 Field not empty

  • Default = True

  • 1=Yes; 2=No

  • Yes/No

  • Y/N

  • True/False, T/F

  • 1/0

O

MATCHON_BARCODE

 

Boolean

Default to Y if Barcode Fields not empty

  • Default = True

  • 1=Yes; 2=No

  • Yes/No

  • Y/N

  • True/False, T/F

  • 1/0

P

REINITIALISE_STOCK

 

Boolean

  • Default to N if no entry

  • If Y, this will re-initialise the stock, create a new stock record and zero out previous records and set the new imported stock record to the current record (like Stock-Reinitialise function) 

  • Default = False

  • 1=Yes; 2=No

  • Yes/No

  • Y/N

  • True/False, T/F

  • 1/0

Q

QTY

 

Numeric

This will be the qty on hand that will be created for the stock record.

XXXXX.XX

R

COSTEXEACH

 

Decimal

  • This will be the cost that is used for the stock records

  • You must enter either CostExEach or CostExTotal

XXXXX.XX

S

COSTEXTOTAL

 

Decimal

  • If no value is entered in CostExEach, use the CostExTotal to determine cost

  • The CostExTotal will be divided by the QTY to work out a CostExEach

  • You must enter either CostExEach or CostExTotal

XXXXX.XX

 

Attachments: