📥 Import: Product Updates & Creation
If you have a large catalogue and need to update many products at once, you can provide that data in the form of a bulk CSV file. While we always advise updating product data directly through the Optiply frontend or our public API when possible, the import tool is perfect for mass updates.
This guide covers how to update existing products yourself, as well as the specific exception process for creating brand new products.
🔄 1. Updating Existing Products (Frontend)
To update products that already exist in your webshop, you can use the built-in import tool in your Optiply dashboard.
Remember: Your file must be in a .csv format.
Step 1: Navigate to Imports
Go to the Product Page, select Webshop Products, and then click on Imports.
Step 2: Choose Your Identifier
You must tell the system how to match your file to the correct products. Choose your preferred identifier (Optiply ID, SKU, EAN, or Article Code) and click Next.
Step 3: Review Attributes & Download Template
On this screen, you can download a template and see a list of all the webshop product attributes available for import (along with their API descriptions). Once you have your CSV file ready, click Next.
💡 Missing an attribute? If you don't see the specific attribute you want to update on this list, it is likely a supplier product trait. You will need to use the Supplier Product Imports tool instead!
Step 4: Upload Your File
Drag and drop your CSV file into the designated area and click Next.
Step 5: Match Your Columns
Match the column headers from your CSV file to the corresponding columns used by Optiply's API. (For example, mapping your status column to set a product to "phased out"). Once all columns are matched, click Next.
Step 6: Final Check & Import
Optiply will run a final check. If any of your columns are mapped incorrectly, the system will flag them here so you can fix them. Once corrected, click Import to start the process!
📊 2. Tracking Your Import & Viewing Reports
Once the import starts, you can track its progress by navigating to Settings > Data Management > Imports/Exports.
When the file is finished processing, you will be able to view a detailed report. The report splits your data into two clear columns:
Succeeded: All the lines in the file that were successfully updated.
Skipped: All the lines in the file that were skipped, rows that were intentionally not processed — not errors, but not updated either.
Common reasons:
- The data matches what's already in the system (no change needed)
- A required reference (e.g. product EAN/SKU) wasn't found, so the row was ignored rather than failed
- The row was a duplicate within the same file
- A field value was outside the accepted range or format but not strict enough to errorFailed: All the lines that encountered an error and were not updated.
➕ 3. Exception: Creating New Products
While the frontend tool is great for updates, it is not possible to create brand-new products through the frontend. In some exceptional cases, it is possible to post (create) products that do not yet exist in the webshop through a bulk import, but this file must be processed manually by our team.
Required CSV Format for Creation:
Your .csv file can hold all the elements available from a standard update file, but it must contain the following columns to successfully create a new product:
Column Header | Data Type | Required? |
name | String | Yes |
unlimitedStock | Boolean ( | Yes |
stockLevel | Integer | Yes |
skuCode or eanCode | String | Yes (Choose one) |
status | Enum ( | No |
notBeingBought | Boolean ( | No |
resumingPurchase | Date ( | No |
minimumStock | Integer | No |
ignored | Boolean ( | No |
📥 [Download the Product Creation CSV Template Here]
How to Submit:
Ensure your file is strictly formatted .csv. Send the file to support@optiply.nl, and our team will process the list and create your new products as soon as possible.
❓ 4. Frequently Asked Questions (FAQs)
Why can't I find the purchasing price or lead time in the product update template?
Purchasing details like cost, lead time, and minimum order quantities are tied to the supplier, not just the product itself. To update these attributes, you must run a Supplier Product Import rather than a standard Webshop Product Import.
Can I create new products directly in the Optiply dashboard?
No. The frontend import tool is exclusively for updating existing products. If you need to create entirely new products in bulk without syncing them from your main integration, you must format a creation CSV and email it to our support team.