Product and/or supplier information can be added to our system in several ways.
Here is a brief description of how to import files from the front end.
From the product page, you have an option to both export and import files. To import a file, follow the instructions below:
Click on the Import option:
A pop-up will appear requesting the Identifier (code by which the product is identified in Optiply, the most common being SKU Code or EAN code).
By clicking Next, you can get started.
This will open a pop-up that will show you the columns you are allowed to import for product updates.
By clicking Next, you have the option to choose a file or drag and drop the file you want to import.
Click Next, and you'll see your file. Here you have a few options to select, like the Encoding Format and select the First row as a header.
(This should be selected if the file has the first column as a header; otherwise, it should not be checked.).
On this next option, you can match the columns if the file has different column names from the required ones.
Select Next, and the import will start. Depending on the size of the file, this can take some time. You can track the progress from the imports page by going to Settings and selecting Imports/Exports.
On this page, not only can you track your import, but you can also check for errors when it is finished by clicking on the exclamation mark
You can see the details and how to create the files in the links at the end of this page.
Depending on the size of the file this process can be almost immediate or take a bit longer.
From the product page, only product attributes will be imported.
From the supplier page, only supplier settings will be updated
Supplier product attributes are not available for import yet.
If you need assistance to convert a .xlsx file into a .csv file, check out this page
When a file is not imported, you'll be informed by the message displayed under the status column.
Here are the import statuses you might see:
IN QUEUE - The import is queued to be processed.
IMPORTING - The data is being imported.
COMPLETED - The import concluded successfully.
COMPLETED WITH ERRORS - The import concluded with errors.
INVALID OPERATION TYPE - The operation type of this import is invalid.
FAILED HEADERS - The validation of the import headers failed.
FAILED WITH VALIDATION ERRORS - The import failed due to errors in the data validation.
FAILED UNEXPECTEDLY - The import failed with an unexpected error.
You will also be able to see the specific errors by clicking on the exclamation point. This will open a new page with detailed information about the sku/s that were not updated and why.
The most common reasons are: there is an error in the data, or the product does not exist in Optiply.
We advise updating information in the front end or adding the data via our public API. If you encounter any difficulties, please reach out to us, and we will assist with this process.
The information must be provided in a fixed format. The file must be a CSV file, separated by commas. Send the file to support@optiply.nl or by chat message, and we will process the list for you within 48 hours.
Read the articles below to find out which information you can import and how:
Import Products (import product attributes)
Import Suppliers (import supplier information)
Import Supplier Products (updates on supplier product attributes)
Import Product Compositions (composed and assembled products)
Import Sales Data (sales orders)