For products in a 3PL environment please follow this article
If you would like to manually upload several products into PULPO WMS you can use the CSV upload feature.
The CSV Template can be found in the Products section of the Web Application.
Here you can find the template.
Make sure to use exactly the format specified in the template for each entry and separate the values by ",".
Note: If using Excel, be sure to save every CSV file you edit in UTF-8 format before uploading.
Upload template details:
Column | Field | Name or corresponding field in Frontend | Description | Field required? | Data example | Format |
A | name | Name | The name of the product, must be short but descriptive | true | Gorgeous Steel Hat 0.1.4 968616 | text, max length 255 |
B | active | Active | Product is active | true | true | true or false |
C | SKU | SKU | The stock-keeping unit, Product reference number | true | HHI626N7 | text, max length 255 |
D | management_type | Management type | Determine the type of product. | true | serial | lot, serial, or none (no capital letters) |
E | supplier_product_id | Supplier product id | Reference number that corresponds to the supplier of a product within your ERP (optional, put 1 as default or test) | false | P-1595003526962-32597 | text, max length 255 |
F | description | Description | Detailed Info regarding a product | false | Impedit harum reprehenderit accusamus aut et. | text, max length 255 |
G | purchase_measure_units | Purchase measure unit | Indicates the appearance of a product when it is purchased | true | BOX | text, max length 255 |
H | minimum_purchase_unit | Minimum purchase unit | Minimum purchase unit (If there is a minimum as multiple that has to be purchased) | true | 1 | integer number greater than 0 |
I | units_per_purchase_package | Units per purchase package | Number of units per package in the purchase (If a product comes in a BOX of 12, then when receiving the user has the option to simply receive for example 3 boxes = 36 individuals) | true | 1 | integer number greater than 0 |
J | sales_measure_units | Sales measure unit | Indicates the unit of a product when it is sold | true | UNIT | text, max length 255 |
K | minimum_sales_unit | Minumum sales unit | The minimum unit of sale (If there is a minimum as multiple that has to be sold, for example to not open boxes) | true | 1 | integer number greater than 0 |
L | units_per_sales_package | Units per sales package | Number of units per package for sale | true | 1 | integer number greater than 0 |
M | cost_price | Cost value | The average cost of the Product (optional, put 0 if not used) | true | 1 | decimal number |
N | barcodes | BARCODES | Product barcode, separated by a comma | true | 9795727349723,9795727349724 | list of text separated by comma, max length 255 |
O | attributes | ATTRIBUTES | Extra attributes separated by comma: name1:value1,name2:value2 (optional for advanced functionality) | false | adjective:Fantastic,attribute:Odit sit aliquam voluptatem voluptatibus inventore?,material:Steel,name:Table | List of (text:text) separated by comma |
P | product_categories | TAGS | Product Categorie codes (optional, can be used to define warehousing rules) | true | 1234,Ergonomic,category_a | list of text separated by comma, max length 255 |
Q | height | Height | height in centimeters | true | 1 | decimal number |
R | width | Width | width in centimeters | true | 1 | decimal number |
S | length | Length | depth in centimeters | true | 1 | decimal number |
T | weight | Weight | weight of the product in kilos | true | 2198 | decimal number |
U | volume | Volume | The volume of the product in cubic centimeters | true | 5815 | decimal number |
V | stackable | Stackable | Can the product be stacked (TRUE/FALSE) | false | false | true or false |
W | batch_control | Verify lot/serial in packing | This option serves to activate or deactivate the batch control during the packing process (TRUE/FALSE) | false | false | true or false |
Y | third_party_identifier_number | N/A | Supplier associated with the product (Only identifier number) | false | sometenant_customer_1_id_number | text, max length 255 |
Z | hs_code | HS Code | Product HS code | false | 123456789 | Integer number greater than 0, up to 20 characters |
AA | origin_country | Country of origin | Country of origin | false | Germany | text, max length 255 |