How to use Product Import Tool to add products to your POS System

*ATTENTIONS:

1. Please leave the Product ID blank when you import a NEW product to the system

2. Even if your new import spreadsheet doesn't include the products that have been already imported, the already imported product will NOT be removed from the system

3. Please make sure the SKU, Brand, and Product name of the variants from the same product are the SAME

Shoptiques POS offers multiple ways to add products to your system. If you want to add products in bulk, we offer you a Product Import Tool where you can add products onto a spreadsheet and upload that spreadsheet through the tool. The products on the spreadsheet will then be added to the system - saving you hours to add those products one by one.

This tutorial will teach you how to use our Import Product Tool.

1. Before importing the products, it's important to make sure that the CSV(spreadsheet) file containing the new product information is correct and properly formatted. Please use our standard template which can be downloaded here or found on the Product Import page.

2. After you download the template CSV file, please open it up with the software of your choice (common software includes the MS Excel, Number, and Google Spreadsheet).

3. Please read through the header of each column and understand what you should fill in under each column. Notice that some columns are required while some others are optional. Here are some reminders for the data entry:

     a) Product ID:

• Please leave this column empty when creating a new product. It should only be filled in when you try to update a product. For updating products, please go to this article for further explanation.
• All variants of the same product should share one Product ID

     b) Product Name, Manufacturer Reference ID, Brand - All variants of the same product should share one Product Name.

     e) Base Color - Please pick from the following values: Beige, Black, Blue, Brown, Bronze, Gold, Green, Grey, Orange, Pink, Purple, Red, Silver, Turquoise, White, Yellow, Multicolor.

      g) Size Type - Please pick from the following values: Clothing Numeric, Clothing Small/Medium/Large, Bra Size, Shoes, Pants, Short, Ring Size, One Size, Alphabet, Kids Clothing, Kids Shoes, Toddlers Shoes.

      h) Size - the options for Size depend on the Size Type value you put in.

      i) The values in the "Stock Count" column must be greater than or equal to 0. Negative values will not be accepted.

      j) If your store has multiple locations, then your locations need to be split up on separate lines. So the entire row will be the same for a product, except for the stock count and the location value.

4. Go to the Products page on the POS web app

5. Click "Import" at the top-right corner

6. Click "Select File"

7. Choose the spreadsheet file where you have added all the new products and hit "Open"

8. The system will validate the file and once completed it will say "Validation complete...".

• If there are errors, it will list them out and indicate the affected rows. You can reupload a CSV file with corrections by clicking the "Select File" button in the Reupload CSV section below the error list.

9. When the file doesn't have errors, click the blue "Confirm & Import" button to complete the product import.

10. A message will appear stating "Successfully uploaded [# of products] products".