import product
Product list import is a process that enables stores to quickly and accurately add new products to the POS system. This process can be used when updating new stock or adding multiple products at once, helping to make inventory management more efficient.
Prepare product data: Before starting the import process, product information should be prepared in a CSV file format, including essential details such as SKU Code, Barcode, Category, Product Name, and Price. Stores can download a sample file for importing the product list by visiting the backend at https://dashboard.silompos.com , selecting the Import Product List menu, and clicking Download Sample File to review the required data arrangement and fields.
Precautions for data preparation
The file must be downloaded as a CSV before importing the product list on the website.
All required columns for product information must be filled in.
For similar products that differ only by size or color, use the same SKU Code, but vary the Barcode. The first row of each SKU Code will represent the main product, while subsequent rows will represent different package sizes of the main product.
The Barcode column must be unique in all cases.
If no values are provided for Price, Cost, or Ratio, the system will set default values of 0, 0, and 1, respectively.
Log in to the backend (Silom dashboard):
Go to the management dashboard at https://dashboard.silompos.com .
Navigate to the Product Details menu, then select Import Product List.
Upload Product File:
Click Upload File to start the product import process.
Select the prepared product data file for upload.
Then, click the Upload File button at the bottom right.
Click Verify to have the system check the accuracy of the data, including SKU Code, Barcode, Category, Product Name, and Price. | If the product data is correct, the Notes column will display "Approved" in green. If there are errors, the Notes column will show the reason for "Not Approved" in red. | If the product data is correct, the Remarks column will display "Approved" in green. However, if there are errors, the Remarks column will show the reason for "Not Approved" in red
Confirm Import:
Once the data has been fully verified, click Save to add the products to the system.
The system will process and import the products based on the provided data, which may take a few moments depending on the number of items.
Click Sync on the POS device, then check the product list in the Inventory menu
Steps and methods for importing product list :
Prepare product data: Before starting the import process, product information should be prepared in a CSV file format, including essential details such as SKU Code, Barcode, Category, Product Name, and Price. Stores can download a sample file for importing the product list by visiting the backend at https://dashboard.silompos.com , selecting the Import Product List menu, and clicking Download Sample File to review the required data arrangement and fields.
Precautions for data preparation
The file must be downloaded as a CSV before importing the product list on the website.
All required columns for product information must be filled in.
For similar products that differ only by size or color, use the same SKU Code, but vary the Barcode. The first row of each SKU Code will represent the main product, while subsequent rows will represent different package sizes of the main product.
The Barcode column must be unique in all cases.
If no values are provided for Price, Cost, or Ratio, the system will set default values of 0, 0, and 1, respectively.
Log in to the backend (Silom dashboard):
Go to the management dashboard at https://dashboard.silompos.com .
Navigate to the Product Details menu, then select Import Product List.
Upload Product File:
Click Upload File to start the product import process.
Select the prepared product data file for upload.
Then, click the Upload File button at the bottom right.
Click Verify to have the system check the accuracy of the data, including SKU Code, Barcode, Category, Product Name, and Price. | If the product data is correct, the Notes column will display "Approved" in green. If there are errors, the Notes column will show the reason for "Not Approved" in red. | If the product data is correct, the Remarks column will display "Approved" in green. However, if there are errors, the Remarks column will show the reason for "Not Approved" in red
Confirm Import:
Once the data has been fully verified, click Save to add the products to the system.
The system will process and import the products based on the provided data, which may take a few moments depending on the number of items.
Click Sync on the POS device, then check the product list in the Inventory menu
Updated on: 07/11/2024
Thank you!