With the Material POS, you can quickly and easily import products into the system in bulk by using the provided template.
- Navigate to pos.shoptiques.com/products.
- On the top right of the screen, you will see an Import button. Click on the import button.
- Next, download the template for the product import tool. You will need to open the file in either excel or google sheets. You can also download it here.
- Once you've opened the file, you can start to type in your product information. Below are a few helpful tips when filling out the file:
- Product ID - This should be left empty when creating products, but is required when editing products. It must be the same value for all colors and sizes of the product. You can get your product IDs from the variants CSV export
- Style Number - Should match what the manufacturer considers the ID for the product. It must be the same for all colors and sizes of the product
- Product Name* - Needs to be the same for all the variants of a product. Ideally your product name is descriptive
- Brand/Label/Manufacturer* - The brand of your product
- Display Color - Enter a display name for your color. It can be anything you like. If empty, we will use the base color as the display color
- Size Type* - Please refer to the tab called "Size Types" to view available sizes. It is like on your Boutique Admin - helps us understand what kind of sizes your products are. Example: Clothing Numeric, Clothing small/medium/large, Bra Size, Shoes, Pants, Short, Ring Size, One Size, Alphabet, Kids Clothing, Kids Shoes, Toddlers Shoes
- Size* - The size of the variant
- Stock Count* - The current inventory quantity for the variant
- SKU - If empty, the system will generate a SKU for the item. Required when editing products
- Barcode - Maximum 13 characters. If empty, we will use the SKU as the barcode. If you would like your existing barcodes to be read by the new system, please make sure that this number matches the barcode in your current system. Our system can also read the barcodes from your manufacturers, so if your products come with barcodes, you can simply enter them here
- Any columns with a * are required fields.
4. After you've completed filling out the template, you are ready to load in your file.
5. Simply click the Select File button and choose the file from your folder.
6. If you have errors in your file, the POS will tell you where to find those errors and what the error is.
7. If you don't have errors, it will ask you if you want to confirm and import. Push the button and wait until you see a green checkmark appear on the screen. This indicates that the products have successfully imported in.
**NOTE: Please be sure to not navigate away from the import products page while products are loading in. This will cause the import to fail.