Announcement

Collapse
No announcement yet.

How to import a spreadsheet of products into EPOS.

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    How to import a spreadsheet of products into EPOS.

    1. We recommend you use this spreadsheet, which is installed on any PC which has SellerDeck EPOS installed on, as a starting point:

      C:\checkout\ImportFile.csv

    2. Open that file
    3. Enter your list of products into the spreadsheet in the same format as the example products already in the spreadsheet. See the notes at the bottom of this article explaining what each field in the spreadsheet are for.
    4. Save the file by clicking on the “File” menu.
    5. Select “Save as“.
    6. Choose the format CSV (comma delimited).
    7. Save it on your Desktop (or anywhere you can easily access).
    8. Now open SellerDeck Epos.
    9. Go to “Data” drop down menu.
    10. Click “Import product data”.
    11. Click “Next”.
    12. Click “Browse” button.
    13. Locate the csv file that you created.
    14. Click “Next” it will take you to “Mapping field”.
    15. Click on the “Auto map” button.
    16. If there is a red question mark under the “import field” that mean you have to manually map it to “Epos field”.
    17. Click “Next”.
    18. Click the “Import” button.
    19. Now a small dialogue box appears saying the import has been finished click ok.



    20. Then click “Ok” and then click “Close”.
    21. Now click on the “Products” button (in Epos software).
    22. You will be able to see the products you added there.


    Valid Fields for Importing

    Region - Select the ‘Price Region’ to which this branch belongs.
    Region 1 - Region1 Price" This is the retail selling price of the product including VAT.
    Product Code – In this field you can enter a unique reference of a product.
    Product Description- In this field you can enter the description of a product (cost, design etc).
    Active- Shows if the product is available for sale or not.
    Stock Level- In this field, enter the current quatity of the product you have in stock.
    Pack Quantity- This field is where you enter how many of something you buy in a pack from your supplier.
    Pack Cost- This field will show how much it will cost to buy a single pack.
    Button Text- In this field you can enter the text for your sales buttons, for example if you want to call your product kids devil costume you can do it here.
    Tax Code- In this field you can enter the code of the tax using for that product. “S” meane the normal rate of tax.
    Category Level 0 –In this field you can add the category of the product for example – costume.
    Category Level 1 –This field is for the sub category of your product.
    Category Level 2- This field is a sub category within a sub category this can be used to show the size of the clothes etc.
    Supplier’s ID - This field is to add unique reference for the Supplier of the product.
    Notes – In this field you can add any notes here for example this product is machine washable etc.
    Image – In this field you can add image of your products.
    Large Image- In this field you can enter larger image for customer to see.
    Barcode –In this field you can enter the unique barcode of the product.
    Ticket Text –In this field we can enter the description of the product so when we print ticket it will appear on the ticket of that product.
    Trade Price- This field will shows the trade price of that product, you can enter the trade price.
    Wholesale Price –This field shows the wholesale price of that product, you can enter the price for your wholesale here.
    Online Price- This field shows the online price of a product. You can enter the price for your online sale here.
    Stock Shift Quantity- This field can be used if you want to scan one barcode but deduct multiple items from stock.

    Updating Existing Products via an Import

    It is possible to update specific fields with an import, such as ‘Stock
    Level’ and ‘Region1 Price’.
    Note: These instructions are based upon Importing from a Standard
    Spreadsheet.
    1. Before you begin the import, make sure that the ‘Update’
    import option is selected rather than ‘Replace’
    2. Map the following required fields:
    • Product Code
    • Barcode*

    *Note: Only map the barcode field if you previously imported
    barcodes. If you do not, new barcodes will be added using the same
    reference as the product code.
    Attached Files
Working...
X