How to Use Product Import in Pipe17

Owned by Sofy Maia (Unlicensed), created
Sept 01, 2021
2 min read

Pipe17 has a new product import function which allows you to create or update products in Pipe17 via a comma-separated-value (CSV) file that you upload. To start the process open the products table in Pipe17 and click on Import Products.

Then download the template and fill in the information you want to use to create or update your product. For update, you only have to supply the name, SKU, and any other fields you want to update, we ignore blank values in a column. This applies to bundles as well, i.e. if you add bundle products in the appropriate columns we create or replace the bundles you add.

This raises some questions about when and how we update. Here are the rules we follow:

  1. Blanks are not processed when updating a product; we do not apply any changes to an attribute unless you explicitly provide a value in that column.

  2. “/“ instructs Pipe17 to overwrite what's already stored with a blank value.

  3. As for bundle handling, the above rules still apply, let’s say a bundle X which consists of three bundle items, bundleItemA, bundleItemB, bundleItemC, we support four scenarios:

    1. All three bundle items are left blank, in that case we skip processing these bundle items, which means the bundle relationship stays the same as before.

    2. If bundleItemA SKU and bundleItemB SKU are left blank, bundleItemC SKU is populated with a specific string, we only update bundleItemC; bundleItemA and bundleItemB are not updated.

    3. If bundleItemA SKU is left blank, bundleItemB SKU is set to “/“, bundleItemC SKU is set to a specific string, then we remove both bundleItemA and bundleItemB and the bundle X now only has bundleItemC.

    4. if all of the bundleItems are set to “/“, this means all bundle items will be removed, and the bundle will be reverted to simple or child. Based on what it used to be.