Tips to format CSV files correctly before uploading to Magestore Purchase Orders

In the Magestore Purchase Orders app, you can save time in updating data by uploading CSV files.

In each case, the file column will have different rules of formatting values. Read this guide carefully to speed up your CSV file preparation.

1. Importing suppliers' file

The suppliers' file includes the following columns:

Field Name	Required	Description
Supplier Code	TRUE	Accept all character types. Do not have spaces between characters.
Supplier Name	TRUE	Accept all character types.
Status	TRUE	Only accept value = "Active/Inactive".
Contact Person	TRUE	Accept all character types.
Supplier Email	TRUE	Only accept the correct email format (ex: aurora@domain.com)
Phone number	FALSE	Accept all character types.
Address	FALSE	Accept all character types.
Apartment, suite, etc.	FALSE	Accept all character types.
Country	FALSE	Accept value that follows the country code list in the world
Region	FALSE	Depends on the selected country.
City	FALSE	Accept all character types.
Postal Code	FALSE	Accept all character types.

The products' file to be uploaded into the supplier profile or purchase order includes the following columns:

Field Name	Required	Description
Handle	TRUE	The product SKU of the product
Option1 Name	FALSE	The title of variant 1 in the Shopify product
Option1 Value	TRUE	The value of variant 1 in the Shopify product
Option2 Name	FALSE	The title of variant 2 in the Shopify product
Option2 Value	TRUE	The value of variant 2 in the Shopify product
Option3 Name	FALSE	The title of variant 3 in the Shopify product
Option3 Value	TRUE	The value of variant 3 in the Shopify product
Cost	FALSE	Only accepts numeric characters and > 0 Only accept dot between integer and decimal characters Automatically round to 2 decimal points if the user fills in the number with more than 2 decimal points
Tax (%)	FALSE	Only accepts numeric characters and > 0 Only accept dot between integer and decimal characters Automatically round to 2 decimal points if the user fills in the number with more than 2 decimal points

With some browsers, the numeric characters may be auto-reformatted. Read here to learn How to stop Excel from auto-formatting numbers in a CSV.