Title: CSV Import Compatibility
Last modified: March 18, 2020

---

# CSV Import Compatibility

 *  Resolved [kimruddock](https://wordpress.org/support/users/kimruddock/)
 * (@kimruddock)
 * [6 years, 2 months ago](https://wordpress.org/support/topic/csv-import-compatibility/)
 * Can related products be imported via CSV using Woocommerce’s native importer 
   function?

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

 *  Plugin Author [WebToffee](https://wordpress.org/support/users/webtoffee/)
 * (@webtoffee)
 * [6 years, 2 months ago](https://wordpress.org/support/topic/csv-import-compatibility/#post-12555795)
 * Hi [@kimruddock](https://wordpress.org/support/users/kimruddock/),
 * You can import related products using CSV by including the product IDs of related
   product in columns named **_crp_related_ids**. While importing make sure to choose“
   Import as metadata” while mapping CSV columns.
 * [Leave us a review](https://wordpress.org/support/plugin/wt-woocommerce-related-products/reviews/#new-post),
   if you like the plugin.
 *  Thread Starter [kimruddock](https://wordpress.org/support/users/kimruddock/)
 * (@kimruddock)
 * [6 years ago](https://wordpress.org/support/topic/csv-import-compatibility/#post-12934659)
 * How do I import multiple IDs under the _crp_related_ids column? I’ve tried comma-
   separating the ids in the CSV but they are just imported as a single string.
 *  Thread Starter [kimruddock](https://wordpress.org/support/users/kimruddock/)
 * (@kimruddock)
 * [6 years ago](https://wordpress.org/support/topic/csv-import-compatibility/#post-12953520)
 * Could you please advise as per my issue above? At the moment I cannot relate 
   more than one product id to each product via CSV.
 *  Plugin Author [WebToffee](https://wordpress.org/support/users/webtoffee/)
 * (@webtoffee)
 * [6 years ago](https://wordpress.org/support/topic/csv-import-compatibility/#post-12958444)
 * Hi [@kimruddock](https://wordpress.org/support/users/kimruddock/),
 * We can help with that.
 * Firstly, copy below code snippet to your active theme’s function.php
 *     ```
       add_filter('woocommerce_product_importer_parsed_data', 'woocommerce_product_importer_parsed_data',10,2);
   
       function woocommerce_product_importer_parsed_data($data,$d_data) {
          foreach ($data['meta_data'] as $mkey => $mvalue) {
              if ($mvalue['key'] == '_crp_related_ids') {
                  $custom_meta = explode(",", $mvalue['value']);
                  $en_value = json_encode($custom_meta, JSON_NUMERIC_CHECK);
                  $custom_meta_data = json_decode($en_value, true);          
                  $data['meta_data'][$mkey]['value'] = $custom_meta_data;
              }
          }
          return $data;
       }
       ```
   
 * Then use the column “Meta:_crp_related_ids” in import CSV with the IDs comma 
   separated.
 * Eg:
    **Meta:_crp_related_ids** 1001, 1002
 *  Thread Starter [kimruddock](https://wordpress.org/support/users/kimruddock/)
 * (@kimruddock)
 * [5 years, 11 months ago](https://wordpress.org/support/topic/csv-import-compatibility/#post-12986858)
 * Many thanks, this has worked.
 *  Plugin Author [WebToffee](https://wordpress.org/support/users/webtoffee/)
 * (@webtoffee)
 * [5 years, 11 months ago](https://wordpress.org/support/topic/csv-import-compatibility/#post-12987312)
 * Hi [@kimruddock](https://wordpress.org/support/users/kimruddock/),
 * Great. Please [leave a review](https://wordpress.org/support/plugin/wt-woocommerce-related-products/reviews/#new-post)
   if you like the plugin.
 *  [nummernegen](https://wordpress.org/support/users/nummernegen/)
 * (@nummernegen)
 * [5 years, 11 months ago](https://wordpress.org/support/topic/csv-import-compatibility/#post-12990568)
 * Hello,
    Is it also possible to add related products by sku? Is there, or can 
   I create, a meta field like: _crp_related_skus ?
 * thanks

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

The topic ‘CSV Import Compatibility’ is closed to new replies.

 * ![](https://ps.w.org/wt-woocommerce-related-products/assets/icon-256x256.gif?
   rev=3157502)
 * [Related Products - Create Upsells, Cross-sells, and Product Recommendations for WooCommerce](https://wordpress.org/plugins/wt-woocommerce-related-products/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wt-woocommerce-related-products/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wt-woocommerce-related-products/)
 * [Active Topics](https://wordpress.org/support/plugin/wt-woocommerce-related-products/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wt-woocommerce-related-products/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wt-woocommerce-related-products/reviews/)

 * 7 replies
 * 3 participants
 * Last reply from: [nummernegen](https://wordpress.org/support/users/nummernegen/)
 * Last activity: [5 years, 11 months ago](https://wordpress.org/support/topic/csv-import-compatibility/#post-12990568)
 * Status: resolved