Troubleshooting Common Errors When Creating Products via Spreadsheet Import in MarketPush

This article covers the common errors you may encounter while creating products in MarketPush through spreadsheet import and provides solutions for fixing them.

Error: Beyond the max product lines (150,000)

Meaning:

Your spreadsheet contains more rows than the system allows for a single import (maximum of 150,000 rows).

Remedy:

    •    Split your spreadsheet into smaller sheets, ensuring each contains fewer than 150,000 rows, then import them separately.

Error: No available product. Please check required attribute values and make sure no empty values

Meaning:

A required field is missing from your import spreadsheet. The essential fields include:

    •    Manufacturer

    •    Manufacturer Part Number

    •    Product Title

    •    Category

Remedy:

    •    Make sure all required fields are present and filled in for each product.

Error: No Manufacturer or Part_number column found

Meaning:

Your spreadsheet is missing either the Manufacturer or Part Number column, which are necessary for product creation.

Remedy:

    •    Add the Manufacturer and Part Number columns to your spreadsheet and ensure they contain valid data for each product.

Error: No category column found

Meaning:

The Category column is missing from your spreadsheet, but it is required for product imports.

Remedy:

    •    Add the Category column to your spreadsheet and ensure each product has a valid category listed.

Error: Required field value can’t be empty

Meaning:

A required field is left blank in one or more rows.

Remedy:

    •    Review your spreadsheet and ensure that all required fields are filled in. Enter values in any empty cells for required columns.

Error: No category value matched

Meaning:

The category listed in your spreadsheet does not match any of the categories available in MarketPush.

Remedy:

    •    Check the available categories in your MarketPush account and update your spreadsheet to match one of these valid categories.

Error: Duplicate value “mfr -> mpn” in these columns

Meaning:

Your spreadsheet contains duplicate products (i.e., the same Manufacturer and Part Number combination).

Remedy:

    •    Remove duplicate products from your spreadsheet and re-import.

Error: Duplicate value “mpin” in the column

Meaning:

There are duplicate values for the MPIN (Manufacturer Part Identification Number) in your spreadsheet.

Remedy:

    •    Identify and remove duplicate values in the MPIN column, then re-import the corrected spreadsheet.

By following these steps, you can resolve common issues encountered during product creation via spreadsheet import in MarketPush.