Product data upload via CSV does not differ much from the non-3PL product data upload.
The main difference with a regular CSV product upload file is 3 fields listed below added to the CSV upload file:
AA | related_sku | The field is used to link a product to the other SKU used for the same product in a different channel |
AB | merchant_slug | Merchant ID, found as described here. The alias name can be used instead of ID |
AC | merchant_id | Merchant ID, found as described here. The alias name can be used instead of ID |
AD | merchant_channel_id | Merchant channel ID, found as described here. The alias name can be used instead of ID. |
AE | merchant_slug | Merchant Alias, found as described here. The alias name can be used instead of ID |
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 | Minimum 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 a 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 Category tag code (optional, can be used to define warehousing rules) | true | 1234, Ergonomic,category_a | List of text separated by a 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 |
X | third_party_identifier_number | N/A | Supplier associated with the product (Only identifier number) | false | sometenant_customer_1_id_number | text, max length 255 |
Y | hs_code | HS Code | Product HS code | false | 123456789 | Integer number greater than 0, up to 20 characters |
Z | origin_country | Country of origin | Country of origin | false | Germany | text, max length 255 |
AA | related_sku |
| The field is used to link a product to the other SKU used for the same product in different channel | true | NA | text, max length 255, |
AB | merchant_id | Merchant ID | Merchant Alias, found as described here | true* | 123 | Integer number greater than 0 |
AC | merchant_channel_id | Merchant's sales channel ID | Merchant channel id, found as described here | true* | 124 | Integer number greater than 0 |
AD | merchant_slug | Merchant Alias | Merchant Alias, found as described here | true* | Merchant_123 | Alias name |
AE | merchant_channel_slug | Merchant's sales channel Alias | Merchant channel Alias, found as described here | true* | Channel_124 | Alias name |
* merchant_id and merchant_channel_id have to be entered either with IDs or with slugs in any combination