If you are a new supplier, you can import an XML or CSV file by going to this step on the Account Verification page or by selecting the Import Products tab from the main menu.
Note: It is possible to import files of up to 500 MB.
If you have not yet imported anything in your account, an empty Import List will appear. Use the Import products button.
The first import step will be displayed: File configuration.
First, enter the name of the import and choose how you will add the supplier's offer file to Droplo: via URL ( https:// ) or by uploading the file from your device ( .xml / .csv ). By choosing the second solution, a window will open in which you will be able to select the file. Once it has been selected, you will proceed to the next import step.
When you select import via URL, a new section will appear. Enter the URL link in the first field.
Here an example of the structure for an XML file:
<?xml version="1.0" encoding="UTF-8"?>
<offers xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1">
<o id="41"
category="Testowe produkty"
categoryalt="Testowe produkty alternatywne 1"
manufacturer="BYTE IT UP" manufactureralt="BYTE IT UP Alternatywny"
name="Testowy produkt 1"
namealt="Testowy produkt alternatywny 1"
price="10.49"
pricealt="15.00"
stock="998412"
stockalt="15"
weight="1"
weightalt="4"
img="https://ijp.pan.pl/wp-content/uploads/2020/04/test.jpg"
imgalt="https://designshack.net/wp-content/uploads/placeholder-image-368x247.png">
</o>
<o id="42"
category="Testowe produkty"
categoryalt="Testowe produkty alternatywne 2"
manufacturer="BYTE IT UP" manufactureralt="BYTE IT UP Alternatywny"
name="Testowy produkt 2" namealt="Testowy produkt alternatywny 2"
price="12.49"
pricealt="15.00"
stock="2137"
stockalt="15"
weight="1"
weightalt="4"
img="https://ijp.pan.pl/wp-content/uploads/2020/04/test.jpg"
imgalt="https://designshack.net/wp-content/uploads/placeholder-image-368x247.png">
</o>
</offers>If the offer is password protected, indicate this below and two additional fields will appear: Username and Password to download the file from the supplier's server.
Sometimes a listing may consist of several links (e.g. one link is product information and the other is prices and stock). In this case, use the Add another file option and complete the new tab in the same way as the previous one. The importer will then recognise the two files as complementary.
Once you have completed the configuration of the file, you can move on to the basic mapping. At this stage, the basic parameters of the file that build its structure are completed.
Both fields should complete automatically. However, it happens that for some reason the ID parameter cannot be read by Droplo. In this case, you should enter the missing parameter into the file or select it manually from the drop-down list.
Once you have selected the appropriate option, proceed to the next step - column mapping.
In this step, there are 2 segments to complete. The first one (left) allows you to assign the corresponding attributes to the Droplo attributes file.
The second (on the right) allows you to manually assign additional information such as price type, currency, delivery time, tax or file language.
In the top right corner, you will notice a button on How to map fields correctly. Use it to read the brief instructions.
It is very important to mark the correct version of the prices that are in the imported file: net / gross.
It is also possible to enter a discount on the prices on file.
Once you have mapped all the required fields on the left and manually completed the rest of the required parameters on the right, proceed to the category mapping.
In this step, you will need to assign equivalent categories from the file to the categories on the Droplo side. You can do this by selecting multiple categories at once, and then set one Droplo-side category for the selected ones.
As of recently, you can also try out our new solution, which we have already introduced in the BETA version - this is AI-based auto-complete of categories. However, this solution may still have difficulties in recognising any file format.
Once you have assigned the right categories, move on.
You should see a screen summarising the correct import configuration. You will also see a Go to Import List button. Use it to check the progress of your product upload to Droplo.
The list of imports shows in turn: the name that was given to the import in step 1 of the configuration, the status of the import, the date of the last update, the number of products detected and correctly imported (1).
In addition, if not all products have been loaded correctly, you can download the import report (2) and check what was at fault for each of the omitted products. If you want to edit (update) or delete an import, use one of the available functions.
The imported products will appear in the Product List tab.
