Import
      Back to home
      1. INTERNAL - Bepoz Help Guides
      2. Installation / System Setup Guides
      3. Import

      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: