Drupal Answers is a question and answer site for Drupal developers and administrators. It only takes a minute to sign up.
Sign up to join this community
I currently have a Drupal website for an art gallery with a content type of Listing (A piece of Art work). Each Listing has a price in a decimal field type.
We are now looking to convert the website to ecommerce using Drupal Commerce, but there is about 500 Listings.
Is there a way to bulk copy/create all the Listings into Products and auto create the product reference and copy the price over as well?
There is no direct option or module which can convert a content type nodes to commerce products. But there are few ways you can do it. You can export your nodes to CSV via node export or views bulk operations and then import those products using commerce feeds module. Another way is to create a custom module and do db_select of all nodes of your particular content type and then create commerce products programmatically. You can use batch process to do this so that php execution time don't break your script.
This is the way I have done this:
Export all nodes of [type] using module Views Data Export https://www.drupal.org/project/views_data_export
Import these as products using Feeds and Commerce Feeds.
Automatically link and manage 1 Product to 1 Node using Auto Product Display https://www.drupal.org/project/commerce_auto_product_display
If anyone wants a more detailed answer as to the exporting/importing/importing with the SKU references, happy to share.
Use the Nid as the Unique Reference
1. Export Nodes
2. Import as Products
3. Import to existing nodes - but only mapped the SKU field for the product reference
