CSV data upload
      Back to home
      1. Home
      2. File management
      3. CSV data upload

      CREATING OR DELETING PRODUCTS IN SHIPPINGBO

      Whether you've just adopted Shippingbo or you need to create a large number of products quickly from a file, you'll need to import them.

      You can also use the product import to update your existing products.

      Add a product via the interface


      This solution is suitable when the quantity of product to be imported does not justify the use of a file import.

      Step 1: Go to your Product Catalogue in the sidebar menu, then click on "Add" :

      Step 2: Fill in the details of this product, then click on "Validate":

      Step 3 (optional) : Add the dimensions of your product once it has been created by going to its product sheet so that Shippingbo can calculate its total volume in m3 (volume is calculated as follows: length X width X height):

       

      CAREFUL

      Only the reference number (SKU) is compulsory and must be unique to avoid errors between your products.

       

      NOTE

      If your product exists on several marketplaces with different part numbers, don't panic! You will be able to enter additional references once the product has been created.

       

      Adding a product by importing a file


      As with all the software, importing a file to add a product is done in CSV format.

       

      CAREFUL

      You can import a maximum of 10,000 products per file. If you wish to import more than 10,000 products, you will need to do so in several imports. 

       

      CAREFUL

      We recommend that you always test with a one-line file before launching your general import. Shippingbo support can take a long time to resolve import problems and may involve additional billing. Please bear this in mind before launching your import and contact us if in doubt for an analysis of your file.

       

      Step 1: To add a product by importing a file, go to Configurations → Files management → Upload→ Product :

      Step 2: To upload a new file, click on "Upload file" :

      Step 3: Fill in the file with the required information. 

      The columns correspond to the following information:

      -userRef: product SKU

      - stock : product stock

      - ean13 : ean13 of the product

      - title : product title 

      - location : location of the product in the warehouse (if applicable)

      - pictureUrl : url of the product picture

      - supplier: supplier name

      - hsCode: product HS code

      - weight: product weight in g

      - height: product height in mm

      - lenght: product length in mm

      - width : product circumference in mm

      - otherRef1 : other Ref 1

      - otherRef2 : other Ref 2

      - ecoTaxCents : eco tax in cents

      - taxRate : tax percentage (ex : 10%)  

      - needEan13Barcode : if you need a barcode

      - customOriginCountry: code of the product's country of origin for customs purposes (ISO code with 2 characters, e.g. CN for China) 

      - description: product description in English for customs purposes

       

      Example of a file : 

      CAREFUL

      Be sure to keep the file headers as they are given here, but delete the example data.

       

      Step 4: Once the file is ready to be uploaded, click on "Drop or select file" and then on "Upload" :

      NOTE

      If you want Shippingbo to calculate the volume in m3 of the products to be imported, add the dimensions of these products in the corresponding columns: weight; height and length.

       

      Updating a product by importing a file

       

      Step 1: To update a product by importing a file, go to Configurations → Files management → Upload→ Product :

      Step 2: Click on "Upload file", select "Update" in "Action" and download one the example file : 

      Step 3: Fill in the file with the information to be updated.

       

      CAREFUL

      Be sure to keep the file headers as they are given here, but delete the example data.

       

      Step 4: Once the file is ready to be uploaded, click on "Drop or select file" and then on "Upload" :

      Example of a file to update a product : 

       

      NOTE

      You can add the product's country of origin to the import in the customOriginCountry column.

      - You can leave the page before the import is complete

      - There is no limit on the size of the importable file.

       

      Deleting products in Shippingbo



      With this import, you can permanently delete products from your Shippingbo catalogue.

      To delete products from the product catalogue, follow the steps below:

       

      Step 1: Go to Configurations → Files management → Upload→ Product :

       

      Step 2: Click on "Upload file", select "Destroy" and dowload the corresponding sample file : 

       

      Step 3: Fill in only the first column with the ID of the products to be deleted (or SKU if you have downloaded the SKU file): 

       

      CAREFUL

      Be sure to keep the file headers as they are given here, but delete the example data.

       

      Step 4: Once the file is ready to be uploaded, click on "Drop or select file" and then on "Upload" :

      Once the file has been correctly uploaded, the products will have been deleted.

       

      Deleting products from a Multi-Shippingbo account
       


      To delete products on a Multi-Shippingbo account, several recommendations must be followed: 

      - The products to be deleted must have a stock level of 0
      - The products to be deleted must no longer be in any location on the WMS account.
       

      You then need to complete the next 2 steps:

      Step 1: Delete the desired products from the WMS account as described in the previous section.

      Step 2: Delete the desired products from the WMS account as described in the previous section.