Importing Excel file as a way to create or update Products

Modified on Thu, 11 Jan at 1:49 PM

This Knowledge Base article illustrates how to use an Excel import feature to create or edit multiple products concurrently in Flawless POS, a tool that is useful for efficient inventory management. To create new products, start in the 'Product List' module under 'Inventory', and select 'Import from CSV'. After selecting the appropriate vendor and uploading the CSV file, ensure that data fields are accurately mapped to Flawless POS fields, like SKU, Product Line, Retail Price, and Cost. Confirm this preliminary mapping before importing, which should result in the new products appearing in your list with all corresponding information. To update existing products, ensure the SKUs match the products you intend to update. The system will use the SKU to determine which products to update. The rest of the process is similar to creating new products. At the end, confirm that the updated fields, like the Product Line, reflect correctly on your products. 


How to use Excel Import Feature


NOTE: If you select the Vendor at the Review Import step — all items will be updated to that vendor. To avoid that, please do not select anything and leave this field as "-Select Vendor-"

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article