Hi and thanks for the module!

I am using a simple csv file for importing:

"Title","SKU"
"test","TEST-SKU-001"

When I run the import it says:

Created 1 commerce product.

but I cannot find any new products here: admin/commerce/products

Thank you very much!

Comments

pcambra’s picture

Status: Active » Postponed (maintainer needs more info)

Did you try the csv example file from this module? Does that one work?

wright.cayley’s picture

Did this issue ever get sorted out. Because I can't find my commerce products either? The module imports but still can't find them:(

William Aubert’s picture

Hello,

I think I have a similar bug. I am trying to import 158 products with "commerce feeds". After several attempts (there were some false image url in my csv) with the option "Update Existing products", the result of the import seems to be correct on the 2 "Feeds importers". I can read on the 2 confirmation messages, 158 imported and 158 products_display in total.

Despite of this I only see 65 products on the admin product page.

If I look in the database:
SELECT * FROM `commerce_product` -> 158 lines
SELECT * FROM `field_data_field_product` -> 65 lines
SELECT * FROM `node` WHERE `type` LIKE 'product_display' -> 158 lines

It seems that the id of the missing products are not in `field_data_field_product'.

Should I delete all products and reimport everything ?
It would be a shame because there has been already some changes in the content.

pcambra’s picture

It would be helpful to get a csv file with a way to reproduce this problem.

Could this be caused by missing required fields?

William Aubert’s picture

Sorry, I finally deleted all products and reimported the same csv file without errors. Now everything is OK.
The problem is probably the fact that I tried to import display_products while I still had errors in the import of products...

vacho’s picture

I've tested with 7.x-2.5 kickstart commerce, commerce 7.x-1.3 feeds.
Importing the following XML

<?xml version="1.0" encoding="UTF-8"?>
<data>
  <node>
    <p>
      <codprod>1358013DURDURANTT</codprod>
      <descrip>1358013 Durant 70T</descrip>
    </p>
    <t>
      <precio>55.5</precio>
     </t>
  </node>
  <node>
    <p>
      <codprod>1358015METCRUISERIST</codprod>
      <descrip>1358015 Cruiser IS12 73T</descrip>
    </p>
    <t>
      <precio>56.6</precio>
    </t>
  </node>
</data>

Retrive the producst with XPATH XML PARSER
Context //node
Product SKU = p/codprod
Title = p/descrip
Price = t/precio


1. The products created are not shown in the list of menu items store> products
(So ​​I think the problem is in this view)

2. Products created itself can be seen creating another view, you can buy.

3. If you have a single mistake in xml data that make possible not loaded the title of the product

HOWEVER IF THE SAME XML, DRUPAL 7 + COMMERCE MODULE + FEEDS, FEEDS COMMERCE, ETC ETC... IN THIS CASE ALL WORKS PERFECTLY AND ALSO DISPLAYED PRODUCTS FROM THE MENU
STORE> PRODUCTS

pcambra’s picture

Status: Postponed (maintainer needs more info) » Active

Ok finally got what is happening and opened an issue on Kickstart to see what we could do to solve it #1954150: Add the product listing (variations) back to the menu

You guys need to import both the display and product to get this working, importing products will only import what kickstart calls variations.

Setting back to active but there's little we could do here, I'll try to get the variations listing back to kickstart and then add a notice in the project page (commerce feeds) for kickstart 2 users.

Any help on documenting how to get products right in kickstart 2 is highly appreciated.

jyg’s picture

I've tried the example CSV and my own test CSV. Products are, somehow, recorded but they do not show up in admin/commerce/products nor in admin/content. What's stranger is that when I try to upload the same CSVs a second time, the importer is aware that I'm trying to upload products already uploaded, and yet when I alter the admin/content view to not filter out products, variants, etc., they still do not show up. If they do get created as variants, as another commentator said, how do they get connected to products, especially if I cannot find them?

I'm surprised there has been no traction on this from the module developers, as this seems a substantial issue with multiple threads pointing to this one. Does this imply that this is really not a problem and I'm just not aware of how this module works?

[edit]
I've had the same results with the latest 1.3 release of Aug '12 and the dev from Feb '13.
[/edit]

Ivan_Dagreat’s picture

Issue summary: View changes

Was there a solution for this? I have the same issue.