With Elovate you can easily create an import job, based on the mapping and settings of your choice.
Go to the link Import / Export > Import in the left sidebar
Click on the button 'Add new import job'
Create new import
You will see the following page:
Name:
Give your import job a readable name
Target store:
Determine to which store you want to send your data to. Global will send the data to 'All Store Views'. Selecting a specific store will send the data to this specific store view.
File type:
Option to choose between CSV, Excel and Google Sheets
Multi select delimiter:
Select the delimiter you have selected for your file.
Create new products on missing SKU's
This option will allow us to create new products, when Elovate finds SKU's in your import file which do not exist in your store yet. Enabling this option will add new options:
Select an attributeset:
Select the attribute set you want to add the new products to. You can always override this setting in your import file. If the attribute set is not present in your import file, Elovate will use this setting as a fallback.Set status for new products:
Determine what status the newly created products will have. This can be overridden in your import file. If the attribute set is not present in your import file, Elovate will use this setting as a fallback.Choose website to assign products:
Select the websites you want to connect these new products to. You can leave empty if needed. This can be overridden in your import file. If the attribute set is not present in your import file, Elovate will use this setting as a fallback.
Assign products to parent categories:
This will allow you to only specify the deepest category ID. With this option active, Elovate will automatically assign the product the parent categories of the ID you have selected.
Once you have selected your file, Elovate will create a data mapping based on the column headers of your import file. Any column headers that can be mapped automatically, will be mapped by default.
When the mapping is created, it's possible to select "update empty," enabling fields without content to overwrite existing content. Choosing "Skip update" allows the skipping of updates, even if there are updates present. The "Delete" option deletes the entire row.
When you have mapped all the attributes to your liking, you can click 'Validate import'. Elovate will run the validation based on your import file.
NOTE: you will be redirected to your import overview. Once Elovate is done validating your import, you will receive a message in your browser.
Click on your validated import to review it. New tabs will show.
Fix errors
When Elovate detects errors in your file, these will be grouped and listed in the tab 'Fix errors'. Within this tab, you can map the errored options to existing attribute values in Elovate:
We have the following options:
Skip value: this will update the selected row, but will skip the errored item from import
Skip item: this will completely skip the item from importing
Attribute: you can select an existing attribute value to map your import value to
After fixing the errors above, you can click on 'Save settings and validate import'. Your import will be re-validated and you will redirect to the import overview. Again, once your import is validated, you will receive a notification in your browser.
Review and import
Once your import is ready to import, you can review the data to import. Click on the tab 'Review and import' to review your data:
Schedule import
You can schedule your import to a date and time you select. Your import will be scheduled to run on this specific date and time.
Once you are finished building your import, you have 2 options:
Run import: this will run (or schedule) your import and will be processed.
Save for now: this will save your data, but will not process your import, in case you will run it at another moment.
Logs
Once your import is run, you will be able to view the logs. The logs will tell you how many products have been added or updated. Within this view, you can revert your import, in case you have made an error.
Synchronisation Log
The result of the import can be found in the Synchronisation Log. The synchronisation log within your import will show you all of the imported data.