Failed to import products

  • Resolved wadaboa

    (@wadaboa)


    5 years, 11 months ago

    Hi,
    I have the latest version of the plugin and whenever I try to import something I get the error “Failed to import products”. I looked at the FAQs and I checked that my CSV file is utf-8 encoded.
    The logs of the import are the following:

    2020-05-26T11:08:55+00:00 DEBUG —[ New Import ] PHP Memory: 256 MB, WP Memory: 40 MB
    2020-05-26T11:08:55+00:00 DEBUG Parsing products CSV.
    2020-05-26T11:08:55+00:00 DEBUG Finished parsing products CSV.
    2020-05-26T11:08:55+00:00 DEBUG —
    2020-05-26T11:08:55+00:00 DEBUG Processing products.
    2020-05-26T11:08:55+00:00 DEBUG > Row 1 – preparing for merge.
    2020-05-26T11:08:55+00:00 DEBUG > > Skipped. Cannot find product with sku 853. Importing instead.
    2020-05-26T11:08:55+00:00 DEBUG > Row 1 – preparing for import.
    2020-05-26T11:08:55+00:00 DEBUG > > Raw Term CASCIONE ID = 1526
    2020-05-26T11:08:55+00:00 DEBUG > > Raw Term ARGENTINA DES. 1300 ID = 1668
    2020-05-26T11:08:55+00:00 DEBUG > > Raw Term 145 ID = 136
    2020-05-26T11:08:55+00:00 DEBUG > > Raw Term 105 ID = 1669
    2020-05-26T11:08:55+00:00 DEBUG > > Raw Term 100PL ID = 656
    2020-05-26T11:08:55+00:00 DEBUG > > Raw Term S/S 21 ID = 1467
    2020-05-26T11:08:55+00:00 DEBUG > > Raw Term WEIGHT/M2 -ROTARY PRINTED- TWILL ID = 1852
    2020-05-26T11:08:55+00:00 DEBUG > > Raw Term /MT ID = 172
    2020-05-26T11:08:55+00:00 DEBUG > > Raw Term PL ID = 117
    2020-05-26T11:08:55+00:00 DEBUG > > (539) Term collections (product_cat) exists? Array
    (
    [term_id] => 17
    [term_taxonomy_id] => 17
    )

    2020-05-26T11:08:55+00:00 DEBUG > > (539) Term 10days (product_cat) exists? Array
    (
    [term_id] => 1352
    [term_taxonomy_id] => 1352
    )

    2020-05-26T11:08:55+00:00 DEBUG > > Raw Term YES ID = 1371
    2020-05-26T11:08:55+00:00 DEBUG > > Raw Term 50 ID = 1527
    2020-05-26T11:08:55+00:00 DEBUG > Inserting
    2020-05-26T11:08:55+00:00 DEBUG Failed to import product “”
    2020-05-26T11:08:55+00:00 DEBUG Finished processing products.

    As you can see, it fails without telling me why. If it’s necessary, I can provide you the CSV file, which has just 1 row.

    Please let me know. Thanks,
    Alessio Falai.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author WebToffee

    (@webtoffee)

    5 years, 11 months ago

    Hi @wadaboa,

    Could you please share with us your importing CSV file so that we can check it. You may please share it with us by uploading to Google Drive or any similar service and sharing the link. Or else you may please send it to us via support.

    Thread Starter wadaboa

    (@wadaboa)

    5 years, 11 months ago

    This is the link to the CSV file:
    https://drive.google.com/file/d/1a1B2WhgJ735CJ02sPnolJOIcehrQ4eTE/view?usp=sharing

    When I import, I choose the delimiter “Semicolon” and I apply the following mapping:

    Price: Regular Price -> PRICE
    Images/Gallery -> IMAGES
    Product Categories -> GRP
    Product Title -> ARTICLE
    Product SKU -> ID

    Notice that the “ID” column is mapped to the SKU in WordPress. The other mappings are just product global attributes.

    Please let me know. Thanks,
    Alessio Falai.

    Thread Starter wadaboa

    (@wadaboa)

    5 years, 11 months ago

    I found the error:
    I was mapping a column (ARTICLE) in the CSV file to two different fields (Product Title and attribute:pa_articolo). I don’t know why but in this way the import failed. Is it a problem you are aware of or is it a feature for some specific reasons?

    Thanks anyway,
    Alessio Falai.

    Plugin Author WebToffee

    (@webtoffee)

    5 years, 11 months ago

    Hi @wadaboa,

    The issue you are facing is because the column that you have mapped to the product title field is also mapped to the attribute field. This version of the plugin does not support the mapping column to multiple fields. You may have a look at the premium version of the plugin which supports multiple mapping.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Failed to import products’ is closed to new replies.