The Imports page shows all the imports that have been performed by your organization.
Before reading this section you can also take a course about Imports and Exports on Productsup Academy.
To locate the Imports page:
Go to Imports from the main sidebar.
All imports are presented in a table:
The column Current status gives a summary of the amount of products that have been found, inserted, and/or updated.
The column Saved products shows you if this particular import has saved any products in the system. No means the import is probably a test run, or dry run’.
The column Channel shows the import channel.
The column User shows the user who oversaw the import details.
The column Started at shows the date and time the import was performed on.
Three dots icon lets you open the possible actions:
Download import
Restart import
Delete import
Restart import
To restart import:
Select three dots in the import row.
Select Restart import.
Select the necessary checkboxes for the data that should be updated:
Title - the titles of products are updated.
Brand - the brands of products are updated.
Category - the categories of products are updated.
Multiple variants - the master data should be skipped and only variants should be changed. It is possible to change multiple variants by checking this field. When checked, the field ‘Variant column’ comes up, where a column for the variant to be added to your import data should be filled out.
Dry run - activates a test run. This means products will not be imported into the system. A test run can be used to check your products and data for faults. If any faults are detected, these can be solved so the import will run properly.
Update variants - the variants of products based on your master data are also updated when an import is run.
Remove leading zeros - removes zeros (0) at the beginning of EAN to fit a certain length. Note: A zero at the beginning of an EAN code could be an actual part of the EAN. Check manually if your starting zeroes should be removed.
Select Finish.
Create an import
To create a new import:
Select the CREATE IMPORT button in the top right corner.
The New import pop-up ones where you need to add or select the necessary information:
In Settings fill out the following:
In Channel, choose the communication channel for this import. If the channel of this restarted import should be different from the original import, you should change it by selecting a different channel in this dropdown field.
In Import Mapping, select mapping for the import from the list.
In Language, you can choose the language that your import will be provided in from the search bar which comes up when the field is clicked. This will be automatically filled if a standard language has been set before.
In Upload do the following:
Select Choose and select the necessary file from your computer.
Select Upload to upload the file.
Select Next.
In Optional, select the necessary checkboxes:
Title - the titles of products are updated.
Brand - the brands of products are updated.
Category - the categories of products are updated.
Multiple variants - the master data should be skipped and only variants should be changed. It is possible to change multiple variants by checking this field. When checked, the field ‘Variant column’ comes up, where a column for the variant to be added to your import data should be filled out.
Dry run - activates a test run. This means products will not be imported into the system. A test run can be used to check your products and data for faults. If any faults are detected, these can be solved so the import will run properly.
Update variants - the variants of products based on your master data are also updated when an import is run.
Remove leading zeros - removes zeros (0) at the beginning of EAN to fit a certain length. Note: A zero at the beginning of an EAN code could be an actual part of the EAN. Check manually if your starting zeroes should be removed.
Overwrite data - is checked by default.
Select Finish.
View import details
Expand a selected import row to see the import details.
If the field Dry run is checked, this import had a test run. This means products were not imported into the system. A test run can be used to check your products and data for faults. If any faults were detected, these can be solved so that the import will run properly.
If Update variants is checked, the variants of products based on your master data were also updated when the import was run. If this field is not checked, variants were skipped and their data was not changed.
If Update brand is checked, the brands of products were updated with this import. If unchecked, brand updates were skipped. The field is automatically checked at the start when creating an import.
If Update Category is checked, the categories of products were updated with the import. Unchecking this makes it so that category updates are skipped. The field is automatically checked at the start when creating an import.
If Update title is checked, the titles of products were updated with the import. Unchecking this makes it so that title updates are skipped. The field is automatically checked at the start when creating an import.
If Trim leading 0 values in EAN is checked, the platform removes zeros (0) at the beginning of EAN to fit a certain length. Note: A zero at the beginning of an EAN code could be an actual part of the EAN. Check manually if your starting zeroes should be removed.
Channel shows the communication channel that was chosen for this import is shown.
Language shows the language that your import will be provided in from the search bar which comes up when the field is clicked. This will be automatically filled if a standard language has been set before.
Selecting the File button lets you download an Excel file which shows a complete overview of the import with EAN codes.
Mapping shows if any mapping was done.
Next to the information fields is a timeline of the import, showing the dates and times of when the import started, mapping started, products inserted and updated, and when the import was finished. As a standard, the import list is sorted from most to least recent import.
Scheduled imports
The Scheduled imports tab shows you a list of all imports that will happen at a future date and/or time and all the imports that are scheduled to take place at regular intervals.
You can schedule imports for the future, and for imports to be repeated regularly.
Go to Imports.
Select the Scheduled imports tab.
Select the CREATE SCHEDULED IMPORT.
The New scheduled import pop-up ones where you need to add or select the necessary information:
In Settings fill out the following:
In Name, give a name to your scheduled import.
In Channel, choose the communication channel for this import. If the channel of this restarted import should be different from the original import, you should change it by selecting a different channel in this dropdown field.
In Import Mapping, select mapping for the import from the list.
In Language, you can choose the language that your import will be provided in from the search bar which comes up when the field is clicked. This will be automatically filled if a standard language has been set before.
Select Next.
In Frequency, select how often the import should repeat:
Daily
Weekly
Monthly
Every X days at HH:MM.
Select Next.
In Optional, select the necessary checkboxes:
Select at least one source to import: Product attributes or Product assets.
Trim leading 0 values in EAN - removes zeros (0) at the beginning of EAN to fit a certain length. Note: A zero at the beginning of an EAN code could be an actual part of the EAN. Check manually if your starting zeroes should be removed.
Update Brand - sends the updated brands of products.
Multiple variants - the master data will be skipped and only variants will be changed. It is possible to change multiple variants by checking this field. When checked, the field ‘Variant column’ comes up, where a column for the variant to be added to your import data should be filled out.
Update Category - sends the updated categories of products.
Update variants - sends the updated variants of products based on your master data.
Update title - sends the updated tiles of the products.
Paused - the imports are stopped until you choose to resume them again.
Select Finish.
NOTE: You mustn't delete any scheduled imports, as this removes the API from any future imports. No API means no update in product details and no info received by retailers, so this isn't recommended! Ask your admin or Retail platform Support for help.