Updating product data can be done in several ways. We advise you to use the front end or our public API.
Import product updates through Optiply's front-end
In the tutorial below, you can see how to import files through the front end.
After you have created the file to import, you can go to the import section and follow the steps as explained in the tutorial.
Remember: To make an import, all files must be in CSV format and must follow the format as explained below.
To update products, you must go to the Product Page and select Webshop Products, then click on Imports.
You can then choose the identifier for your product, which can be Optiply ID, SKU, EAN or Article Code. Then click Next.
Here, you'll be able to download a template, but also see the attributes that are available to import for the webshop product and their descriptions in our API. If you don't see the attribute you want to import here, then it's probably a supplier product trait, and you need to go to supplier product imports instead. Once you have your file, click Next.
Drop your file here and click Next.
In this example, we are setting a product to phased out.
This is where you match the columns you have in your file to the ones used by Optiply's API. Once this is done for all the columns in the file, click Next.
Here you will see the final check. If one of the columns is incorrect, it will be shown here. The example below shows an incorrect column definition.
Once corrected, you'll see this image, and you can click Import.
Once the import starts, you can track it from your imports page.
For that, you can go to the Imports/Exports Page (follow the link for more information).
Once the file is finished, you'll be able to see the report.
All the lines in the file that have succeded are in that column. All the lines that were not updated are in the failed column.
In some exceptions, it's also possible to post (create) products that don´t exist in the webshop through bulk import.
The CSV file can hold the following columns:
name (required) - string
unlimitedStock (required) - Boolean (TRUE / FALSE)
stockLevel (required) - Integer
skuCode or eanCode (required) - String
status - Enabled/ disabled
notBeingBought - Boolean (TRUE / FALSE)
resumingPurchase - Date (YYYY-mm-dd)
minimumStock - Integer
ignored - Boolean (TRUE / FALSE)
Plus, all the elements available from the update file
A template of this file can be found here.
It is not possible to create products through the front end so send it to us for import. Please make sure that the file is a CSV file. By sending the file to support@optiply.nl we will process the list for you as soon as possible.