Export your Amazon catalog
To import your Amazon products to Poleepo , you'll need to export your inventory from your Amazon account.
You will need to generate two reports for each country active on your Amazon account: Active Offers Report
– Log in to your Amazon Seller Central.
– In the top menu, click "Inventory -> Inventory Reports." – In the
"Select Report Type" field , select "Active Listings Report" and then click the "Customize Report Columns" link. – Check the
"Selected Attributes" box on the right to see if the key data for importing products into Poleepo is present .
If the following fields are not present, add the fields by selecting them from the "Available Attributes" box on the left and clicking the "Add
"
Article Name
Item Description
Prices
Amount
Seller SKU
ASIN 1
Product identifier type
Product identifier
Once these operations are completed, click on the "Save " button at the bottom.
Go back to the “Inventory Report” section (Inventory -> Inventory Report) In the “Select report type:”
drop-down menu , select: “Active Offers Report (Custom)” and click on the “Generate Report” button
Wait a few minutes and the page will contain the link to download the generated reports.
Prepare the file for import.
Preliminary operations
Before importing the offer report generated on Amazon into Poleepo, you need to make some changes to the file “Report+delle+offerte+attiva+xx-xx-xxxx.txt”
Follow these steps:
Rename the file downloaded from seller central from .txt to .csv
Open the CSV file with spreadsheet software (Excel, LibreOffice, OpenOffice, Numbers, etc.)
Configure the opening of the CSV file with the column separator "Tab" and the column type "Text" (This last operation is important to prevent the software from eliminating zeros if there are codes or data with leading zeros)
Find the column that refers to the channel “ Fulfillment Channel ” (The name may vary) and using a filter identify and delete all rows that refer to the AMAZON_EU channels, leaving only three rows that refer to the “DEFAULT” channel .
Add a column to the file and name it “Rate” and enter the rate corresponding to the products for each row.
Save the file.
Import Amazon products
Create the configuration for importing and defining the report file structure
In the left side menu select “Catalogs > Publications”
Click on the “New Configuration” button
Upload report in CSV format in the “File” field
Enable the switch: “File contains header line:”
In the “Column separator:” field , enter “t” ( Tabulation )
.* If you chose a different separator when saving the file, enter it in this field.Click the “Analyze” button
Amazon Channel Choice and Import Behavior
Select the Amazon channel for importing (e.g., AMAZON ITALY)
Leave the “Import publications” option selected
Leave the “Update an existing publication” switch off
Toggle the “If there isn’t a product to associate this publication with, create one” switch.
Click the “Next” button
Filter identifiers
Proceed by filtering the search identifiers, searching by products or publications.
CSV Column Association (Mapping)
Proceed with mapping prices and additional, Amazon-specific fields.
To correctly create an offer, it is recommended to always map (as identifiers) only the SKU and then the identifier and the identifier type: this is because offers are created based on SKU, EAN or ASIN and if all 3 were mapped, they would conflict.
Give your configuration a name and Save .
Then, from the Catalogs>Publications section, under the buttons under Actions, click on the first Play.
Upload the file again, click Preview , and then Run to launch the setup.
