Troubleshooting Common Errors When Importing Offers into MarketPush

This article outlines the most common errors encountered when importing offers into MarketPush via spreadsheet, along with their meanings and step-by-step remedies.

Error: No product found for this combination of MPN and manufacturer

Meaning:

The system couldn’t locate the product you’re trying to add an offer to. This could be due to the product not being created in your account or a mismatch between the manufacturer part number (MPN) and manufacturer name.

Remedy:

    •    Ensure the product is created in your account.

    •    Verify and correct the MPN and manufacturer name combination in your import sheet.

Error: Field is invalid

Possible Causes:

    •    Seller Offer SKU or MPN contains unsupported characters.

    •    Number fields (e.g., lead time to ship, stock quantity, minimum quantity alert) contain invalid entries.

    •    Allow Returns isn’t formatted as Yes/No or True/False (case-sensitive).

    •    Condition field is not set to New or Used (case-sensitive).

Meaning:

Your sheet contains improperly formatted values in the rows that generated this error.

Remedy:

    •    Check the relevant fields and ensure all values conform to the system’s requirements.

Error: [Field] is not a valid date

Meaning:

The date format in one or more rows is incorrect and cannot be processed by the system.

Remedy:

    •    Adjust the date fields to the required format.

Error: No matching location found

Meaning:

The location name listed in your import sheet does not exist in the “Locations” section of your MarketPush account.

Remedy:

    •    Create the location on the “Shipping” page in your account, or ensure that the location name in your import sheet matches exactly (including spelling and punctuation).

Error: [Field] is required but missing

Meaning:

One or more required fields for successful offer import are missing.

Remedy:

Ensure your spreadsheet includes the following required fields:

    •    MPN (manufacturer part number)

    •    Manufacturer (company name)

    •    Seller Item SKU (internal part number)

    •    Stock quantity

    •    Pricing

Error: Invalid Pricing

Meaning:

The pricing data in your import file is incorrectly formatted.

Remedy:

    •    Ensure your pricing follows the correct format required by the system.

Error: Minimum order quantity is less than the smallest price quantity

Meaning:

Your stock quantity is less than the first price break quantity (e.g., if your stock quantity is 1, but the first price break starts at 5 units).

Remedy:

    •    Adjust your stock quantity to match or exceed the first price break quantity.

Error: [number] rows have not been inserted in batch [start line] - [end line] because there is an existing offer for the same combination of seller, location, product, and condition, but with a different offer SKU

Meaning:

This error occurs when there are duplicate offers for the same product, seller, location, and condition, but with a different offer SKU.

Remedy:

    •    Ensure you’re not attempting to import duplicate offers that have already been created either through a previous import or manually.

Allowed Characters for MPN and Offer SKU in MarketPush:

• Letters: a-z and A-Z
• Digits: 0-9.
• Special Characters: . + / # $ ( ) , * & _ (space) | ~ -.

For a sample offer template, click here.