Importing dataPocketSales can import data directly from a standard CSV (Comma Separated Values) file. The first row of the file will be ignored as it is supposed to contain the columns header names. The next rows should contain a product in each row with its fields separated by a semicolon (;) on the following order:
- Reference: Has to be unique (2 or more products cannot have the same reference), and its mandatory to have a reference.
- Name: (optional) The name of the product.
- Price: (optional) Number with a maximum of 2 decimals, you can use a comma(,) or a point(.) for inputting a decimal value, if a price has not been introduced the product will have a cost of 0.
- Category: (optional) Category to which the product belongs.
Its mandatory for each product to have all these 4 fields, even if they are empty.
Example CSV content
REF;Product;Category;Price Or1kg;Oranges 1kg;Fruits;1,02 Pe-150g;Peanuts 150g;Food;1,05 cko100;Chocolate 100g;Sweets;1,2
You can also retrieve and import an example CSV file clicking here or you can copy the url:
Note: If you are using special characters with accents, etc.. make sure you save your CSV file in a valid codification format, for example UTF-8.