Skip to main content
Blog/The Best Way to Import WooCommerce Products from Amazon

The Best Way to Import WooCommerce Products from Amazon

Amazon sellers can import their existing product catalogs into WooCommerce to establish their own online stores without recreating every product manually. However, keeping prices and stock quantities accurate requires updating WooCommerce as Amazon listings change.

Amazon Seller Central’s All Listings Report provides a snapshot of a seller’s products, including SKUs, prices, and stock quantities. A third-party import plugin can use this report to create WooCommerce products and update them when newer reports become available.

In this guide, we’ll show you how to import an Amazon listings report and update existing products using WP All Import.

Three Ways to Get Amazon Products into WooCommerce

There are three practical ways to move products from Amazon to WooCommerce. They differ in how much work they take and in whether the sale happens in your WooCommerce store or on Amazon.

MethodWhat the store ends up withWhere it falls short
Manual entryProducts created one at a time in the WooCommerce editorSlow for any real catalog, and prices and stock drift from Amazon with no way to update them in bulk
Amazon API pluginAffiliate listings that pull details from Amazon and send shoppers back to Amazon to buyThe sale and the customer stay on Amazon; access runs through Amazon’s Creators API, which replaced the retired Product Advertising API 5.0
Listings report + importerComplete WooCommerce products with your own prices, stock, and checkoutRequires downloading the report from Seller Central first

Manual entry works if you’re adding a few items, and API plugins suit affiliate sites. For your own catalog, we recommend the listings report, because it already holds every product in one file.

WP All Import turns an Amazon listings report into WooCommerce products in a single import and updates those products from each newer report, which makes the report-based method the most complete option for sellers moving their own catalog.

What’s Inside an Amazon Listings Report

You’ll find the All Listings Report in Amazon Seller Central under Inventory > Inventory Reports. It exports every product you’ve listed, one SKU per row. Amazon delivers it as a tab-delimited .txt file, and its column names follow Amazon’s conventions rather than WooCommerce’s. Here’s how the main columns line up:

Amazon columnWooCommerce product field
item-nameProduct title
item-descriptionProduct description
seller-skuSKU
priceRegular price
quantityStock quantity
image-urlFeatured image
asin1Custom field (ASIN)

The report also includes Amazon-only columns such as fulfillment-channel and open-date, which we leave out of a WooCommerce import. Each row holds one main image per product, so gallery images and variation relationships need to come from additional data mapped during the import.

WP All Import reads the report’s tab-delimited layout as it downloads from Seller Central, so the file goes straight to the import screen without a stop in a spreadsheet editor.

Import Amazon Products with Automatic Setup

WP All Import’s Automatic Setup reads an Amazon listings report, identifies what each column contains, and maps the data to WooCommerce product fields before the import runs. When we ran a sample All Listings Report through it, every Amazon column landed in the right WooCommerce field without any setup instructions. A first import takes four steps.

Step 1: Upload the Amazon Listings Report

Go to All Import > New Import and click Set up automatically at the top of the screen. Upload the report from your computer, or load it through Download from URL, Existing File, or FTP/SFTP. If you save each new Amazon report to the same location, a URL or FTP source saves you an upload every time. The uploader accepts TXT files alongside CSV, XML, and JSON, so the report goes in as Amazon delivers it.

wp-all-import-automatic-setup-select-import-file

Step 2: Select WooCommerce Products

Under Choose What to Import, select WooCommerce, then Products, and click Start Automatic Setup. Automatic Setup recognizes Amazon’s column names, such as item-name, seller-sku, and quantity, on its own, so a standard report doesn’t need anything in the optional Add Setup Instructions field. Accept the data processing consent prompt, and a progress screen tracks each part of the import as it’s configured, including title and description, images, categories, and custom fields.

wp-all-import-automatic-setup-product-import-type-selection

Step 3: Review the Mappings and Preview the Products

The Your Import Is Ready screen shows how many fields were mapped and how many Amazon records will be imported. Expand Field Mappings to check each assignment, grouped under Core WordPress Fields, WooCommerce Import Add-On, Images, Taxonomies, and Custom Fields. Before going further, we always confirm that seller-sku maps to the SKU and price to the regular price.

wp-all-import-automatic-setup-import-ready-screen

Click Preview to see the products before anything is created. Frontend View shows each product page as shoppers will see it, WP Admin View shows the WooCommerce edit screen, and the record selector pages through every product in the report.

wp-all-import-automatic-setup-import-frontend-preview

Step 4: Run the Import

Click Run Import. When the import finishes, the summary shows how many products were created, updated, and skipped. Open Products > All Products to check your new WooCommerce catalog.

WP All Import processes large files in batches, so a report listing several thousand Amazon products runs through the same four steps as one listing a dozen.

wp-all-import-automatic-setup-import-complete

Fine-Tune Amazon Data in Manual Setup

Automatic Setup handles the full mapping, but you may want some Amazon values changed on the way in. Clicking Manual Setup on the Your Import Is Ready screen opens the template editor with every automatic mapping already in place, so you only touch the fields that need changes.

WP All Import runs PHP functions on incoming values during the import, which means an Amazon price, status, or title changes as it enters WooCommerce without anyone editing the source file. These are the two adjustments we reach for most often.

Apply a Price Markup

Amazon prices often reflect marketplace fees that a direct store doesn’t charge, or the reverse. In the WooCommerce Add-On panel, the Regular Price field holds {price[1]} from Automatic Setup. Replace it with [round({price[1]} * 1.10, 2)] to raise every price by 10 percent and round to two decimals.

wp-all-import-manual-setup-price-markup-function

Import Inactive Listings as Drafts

The report’s status column marks each listing as Active or Inactive. To keep inactive Amazon listings off your storefront, expand Other Product Options, select Set with XPath under Post Status, and enter:

[str_replace(“Inactive”, “draft”, str_replace(“Active”, “publish”, {status[1]}))]

The function converts each listing’s status into a WooCommerce post status, so active listings publish and inactive ones arrive as drafts.

Keep WooCommerce in Step with Your Amazon Catalog

WP All Import updates existing WooCommerce products from a newer Amazon report by matching each record on its SKU, so price and stock changes carry over without creating duplicates.

To set up your import for repeat runs, click Manual Setup on the Your Import Is Ready screen and continue to Import Settings:

  1. Select Attempt to match to existing WooCommerce products before creating new ones and match on the SKU.
  2. Check Update existing WooCommerce products with changed data and Skip WooCommerce products if their data in your file has not changed.
  3. To refresh only prices and stock, select Choose which data to update and limit the update to those fields.
  4. Check Remove or modify WooCommerce products that are not present in this import file to handle listings removed from Amazon.

For each new Amazon report, re-run the same import. We recommend loading the report from a URL or FTP location, which lets the import run on a schedule so your WooCommerce catalog refreshes without a manual upload.

Final Thoughts: Import WooCommerce Products from Amazon

Moving an Amazon catalog into WooCommerce comes down to one file and one import tool. The All Listings Report already holds the product data, and WP All Import turns it into WooCommerce products in a single import, mapping Amazon columns such as item-name, seller-sku, and quantity to the right fields automatically. A twelve-product report and a several-thousand-product report go through the same steps, since large files are processed in batches.

After the move, WP All Import keeps prices and stock levels aligned with Amazon by matching each product’s SKU and updating it from every newer report. For a first run, we suggest starting with a recent All Listings Report, previewing a few products, and checking prices and images before importing the full catalog. Once that run looks right, switching its settings to update existing products prepares the same import for every report that follows.

Common Questions About Importing Amazon Products to WooCommerce

Can I import Amazon products to WooCommerce?

Yes. WP All Import imports Amazon products to WooCommerce from the All Listings Report that Seller Central exports, mapping titles, SKUs, prices, stock levels, and image links to WooCommerce product fields automatically. The report uploads as a TXT file, and every product can be previewed on the storefront and in the WooCommerce editor before the import runs.

How do I bulk import products into WooCommerce?

WP All Import bulk imports products into WooCommerce from a CSV, XML, JSON, or TXT file in a single run. To bulk import products:

  1. Go to All Import > New Import and click Set up automatically.
  2. Upload the product file and select WooCommerce > Products.
  3. Click Start Automatic Setup and review the Field Mappings on the Your Import Is Ready screen.
  4. Click Preview to check the products in Frontend View and WP Admin View.
  5. Click Run Import and confirm the created product count in the import summary.

How do I sync Amazon inventory with WooCommerce?

WP All Import syncs Amazon inventory with WooCommerce by updating existing products from each new listings report. To set up the sync:

  1. Upload the Amazon report through Set up automatically on the All Import > New Import screen.
  2. Click Manual Setup on the Your Import Is Ready screen and continue to Import Settings.
  3. Select Attempt to match to existing WooCommerce products before creating new ones and match on the SKU.
  4. Check Update existing WooCommerce products with changed data, then use Choose which data to update to limit updates to price and stock.
  5. Load each new report from a URL or FTP location and schedule the import.

How do I import Amazon affiliate products into WooCommerce?

To import Amazon affiliate products into WooCommerce, use a product file that includes each item’s Amazon affiliate link, then import it with WP All Import. Automatic Setup maps the link to the Product URL field and the button label to Button Text, but it assigns the External/Affiliate product type only when the file has a product-type column. Without one, open Manual Setup and set the product type to External/Affiliate before running the import.

Share
XFBLink