This tutorial shows how to get product data from your PIM onto Amazon. It covers preparing product data, mapping attributes to Amazon's flat-file template, checking the data before you upload it and listing it in Seller Central. It also explains which steps WISEPIM handles today and which happen in Seller Central.
Understanding Amazon PIM integration
Integrating a Product Information Management (PIM) system with Amazon helps sellers manage and publish product data more efficiently. A PIM centralizes all product information, including descriptions, specifications, images, videos, and marketing assets. This centralization makes it easier to maintain accuracy and consistency across various sales channels. For Amazon sellers, this translates to faster product launches, fewer manual errors, and better data quality, which improves search visibility and conversion rates on the marketplace. PIM systems such as WISEPIM help businesses manage complex product catalogs and check listings against Amazon's requirements before they go live.
There are two common routes from a PIM to Amazon. Some PIMs and listing tools connect to Amazon Seller Central through the Selling Partner API (SP-API) and send listing updates directly. The other route is a file: you export product data in the columns of Amazon's flat-file template and upload it in Seller Central. Both routes start the same way: complete product data in the PIM, and attributes (e.g., "color", "material", "size") mapped to Amazon's fields. WISEPIM has no Amazon connection, so it uses the file route: you prepare and check the data in WISEPIM, export it and upload it yourself.
Managing product data for Amazon has specific challenges due to its strict requirements and complex ecosystem. Amazon needs highly structured and validated data, with unique attribute sets for each product category. Managing product variations (e.g., a T-shirt in multiple sizes and colors) requires careful handling of parent-child SKUs. Image requirements are strict, often needing specific resolutions and aspect ratios. Selling internationally on Amazon marketplaces also requires localized content, including translated descriptions and region-specific attributes. Without a PIM, these tasks become time-consuming and error-prone, potentially leading to listing suppression or a poor customer experience. A PIM offers tools to standardize data, manage variations, and localize content, ensuring compliance and optimizing listings.
Preparing your product data for Amazon
Preparing product data for Amazon requires a structured approach to ensure accuracy, completeness, and compliance with Amazon's specific requirements. Start by auditing and cleaning your existing product information. This means finding and correcting inconsistencies, removing duplicate entries, and adding any missing details. For example, check for uniform product titles, consistent attribute values (e.g., "color" instead of "colour"), and accurate product descriptions. A clean dataset prevents integration errors and ensures your listings appear professional and accurate on Amazon. This initial cleanup helps ensure a smooth PIM integration.
Next, identify all Amazon-specific attributes needed for your product listings. Amazon requires certain mandatory attributes that differ from typical internal PIM data. Examples include browse_node (Amazon's category ID), product_type (e.g., "ELECTRONIC_KEYBOARD", "HEADPHONES"), and item_type_keyword (a more granular categorization). You also need standard e-commerce attributes like brand, manufacturer, model_number, and global trade item numbers such as UPC, EAN, or ISBN. For variations (e.g., different colors or sizes of the same product), Amazon uses a parent_child relationship, which requires a variation_theme attribute (e.g., "Color", "Size", "ColorSize"). Understanding these attributes early helps you map your PIM data correctly.
Finally, structure your product data to match Amazon's schema and templates. Amazon offers category templates (often called "flat files" or "inventory files") that specify the exact column headers and accepted values. Tools that use the SP-API send the JSON structure the API expects instead. Either way, attribute names must match Amazon's requirements, and data types (e.g., text, number, date) must be formatted correctly. For instance, a price must be a number, and an image URL must be a valid URL. In WISEPIM, an export template stores the fields, column order and file format for one destination, so you set it up once to follow the Amazon template for your category.
Preparing a "Wireless Bluetooth Headset" for Amazon
A retailer wants to list a new "XYZ-200 Wireless Bluetooth Headset" on Amazon.
- Audit existing data: Confirm the headset has a unique SKU (e.g., XYZ-200-BLK), a clear product name ("XYZ-200 Wireless Bluetooth Headset with Noise Cancellation"), and a complete description. Verify image URLs are high-resolution.
- Identify Amazon attributes: Determine the correct browse_node (e.g., 172541 for "Over-Ear Headphones"), product_type ("HEADPHONES"), item_type_keyword ("wireless-headset"), brand ("XYZ Audio"), manufacturer ("XYZ Corp."), and UPC (e.g., 012345678901).
- Structure for Amazon: Map the PIM attributes to Amazon's flat file or API schema. For instance, map PIM.product_name to Amazon's item_name, PIM.description to product_description, and PIM.main_image to main_image_url. If there are color variations (e.g., black, white), define variation_theme as "Color" and specify parent_child relationships.
Result: The product data is ready for upload, conforming to Amazon's "Electronics" category template, ensuring accurate listing creation and proper categorization.
{
"sku": "XYZ-200-BLK",
"item_name": "XYZ-200 Wireless Bluetooth Headset with Noise Cancellation",
"brand": "XYZ Audio",
"manufacturer": "XYZ Corp.",
"product_type": "HEADPHONES",
"item_type_keyword": "wireless-headset",
"browse_node": "172541",
"upc": "012345678901",
"standard_price": 79.99,
"currency": "EUR",
"quantity": 150,
"main_image_url": "https://example.com/images/xyz200-black-main.jpg",
"product_description": "Experience superior sound quality and comfort with the XYZ-200 Wireless Bluetooth Headset...",
"variation_theme": "Color",
"color_name": "Black",
"parent_child": "child",
"parent_sku": "XYZ-200-PARENT"
}
Getting product data from WISEPIM onto Amazon
WISEPIM does not connect to Amazon, so it does not create or update listings in Seller Central. What it does is get the product data ready and check it before you upload. These are the Amazon tools in WISEPIM today:
- Quality Guard Amazon rule pack: flags missing names, descriptions, prices and SKUs, products without a GTIN or a brand plus MPN, titles over 200 characters and products without an image, and warns on titles under 30 characters, descriptions under 50 words and fewer than four images.
- Channel Readiness: scores your catalog on the fields Amazon asks for and lists the products that miss them. It is a check, not a feed.
- Amazon-style writing and preview: the Marketplace Description (Amazon-style) writing style writes copy made for Amazon listings, and the Amazon preview shows how a product page reads before you list it.
- Imports from Amazon: the WISEPIM browser extension imports products from Amazon product, search and category pages with images, specs and the source URL, and WISEPIM maps Amazon flat-file columns when you import a CSV.
Listing the XYZ-200 headset with WISEPIM
The retailer from the example above has the headset data in WISEPIM and wants to list it on Amazon.
- Check the products against the Amazon rule pack in Quality Guard and fix what it flags, such as a missing GTIN or a title over 200 characters.
- Open Channel Readiness for Amazon to see which products still miss fields Amazon asks for.
- Write or rewrite the title and description with the Amazon-style writing style, and review the result in the Amazon preview.
- Download the flat-file template for the headphones category from Seller Central, and build a WISEPIM export template with the same fields and column order.
- Export the products to Excel or CSV with that template.
- In Seller Central, upload the file under Catalog > Add Products via Upload, then check the processing report for errors.
Result: The headset is listed on Amazon with data that passed WISEPIM's checks first. When the data changes, you fix it in WISEPIM, export again and upload the new file.
Fixing listing errors after upload
After an upload, the processing report in Seller Central lists the rows Amazon rejected and why. Common causes are a missing or invalid product identifier, a value that is not in the template's list of accepted values and images that do not meet Amazon's image rules. Fix the cause in WISEPIM rather than in Seller Central, so the next export carries the fix and your other channels get it too.
