We recommend using both Google Sheets, and Microsoft Excel to complete these steps.
-
In your Maropost Commerce control panel navigate to eBay > View Listings.
-
Set your filters to only show the listings that you would want to export. In this example, the filters have been set to show Ended listings.
-
Click and drag to highlight all the listings that are returned, and copy them to your clipboard.
Please Note: It’s important that the area you copy covers the whole table, from the top left to bottom right corner as indicated with the arrows.
-
Paste this information into Google Sheets.
-
You now need to remove the formatting of the table. Select the table, and go to Format > Clear Formatting.
-
Copy the data, and paste it into Microsoft Excel.
-
Select the table and right click, then choose Remove Hyperlinks.
-
You can now delete any unnecessary columns, such as Edit, Fee, Listed On, and Status. To do this, right click on a column header and select Delete.
-
To change the Information field so that it only shows the quantity, you need to use the find & replace function. Hold down Ctrl and press H. In the find box, type in *Available:. Leave the replace field blank and click Replace All.
-
With the replace box still open, type Out* in the find field and click Replace All.
-
With the replace box still open, in the find field hold Ctrl and press J. You’ll see a small dot in the find field but nothing else. Click Replace All and any line breaks will be removed.
| Data to be extracted | 1st Replace | 2nd Replace |
|---|
| Custom Label | *Custom Label: | Ctrl + J |
| Title | Fixed Price Item Variations | Custom Label:* |
| Price | $ | |
-
All that’s left in the field will be the quantity. You can now perform similar steps on the Item field depending on what data you want to extract.
-
Save your spreadsheet as a CSV file (MS-DOS), and you can use it to import into Maropost Commerce.