Title: Importer issues
Last modified: July 25, 2017

---

# Importer issues

 *  [nemanja09](https://wordpress.org/support/users/nemanja09/)
 * (@nemanja09)
 * [8 years, 10 months ago](https://wordpress.org/support/topic/importer-issues/)
 * Hello,
 * I have two issues with the built-in product import/export:
    1) Export is exporting
   only published posts… How do I change this? 2) Importer is importing only rows
   with a single crosssell sku and ignoring any lines with multiple skus “xxxx|xxxx
   |xxx”
 * The documentation says nothing about this. What am I doing wrond?

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

 *  [Saurabh Jain](https://wordpress.org/support/users/saurabhj91/)
 * (@saurabhj91)
 * [8 years, 10 months ago](https://wordpress.org/support/topic/importer-issues/#post-9353423)
 * Hi [@nemanja09](https://wordpress.org/support/users/nemanja09/),
 * While uploading the product click on SHOW ADVANCE OPTION, you can select CSV 
   Delimiter there. By default it is comma(,) you can change it to pipe(|) or else
   in your csv use comma for multi sku.
 *  Thread Starter [nemanja09](https://wordpress.org/support/users/nemanja09/)
 * (@nemanja09)
 * [8 years, 10 months ago](https://wordpress.org/support/topic/importer-issues/#post-9353432)
 * Humm.. Wouldn’t that break the cell into separate cells?
    My CSV is formatted
   to use commas as delimiters, but I need to split out entries within a single 
   cell/row…
 *  [Saurabh Jain](https://wordpress.org/support/users/saurabhj91/)
 * (@saurabhj91)
 * [8 years, 10 months ago](https://wordpress.org/support/topic/importer-issues/#post-9353467)
 * In that case please select pipe from importer advance option. Which tool you 
   are using to create CSV? you can use google docs for ease.
    -  This reply was modified 8 years, 10 months ago by [Saurabh Jain](https://wordpress.org/support/users/saurabhj91/).
 *  Thread Starter [nemanja09](https://wordpress.org/support/users/nemanja09/)
 * (@nemanja09)
 * [8 years, 10 months ago](https://wordpress.org/support/topic/importer-issues/#post-9353490)
 * I am using Google docs. These files used to work well with the premium CSV import
   plugin from WooThemes, but it’s not working with now built-in importer.
 *  Thread Starter [nemanja09](https://wordpress.org/support/users/nemanja09/)
 * (@nemanja09)
 * [8 years, 10 months ago](https://wordpress.org/support/topic/importer-issues/#post-9353502)
 * The whole question is – what is the secondary delimiter recognized by the importer?
   And the second one is – how to export draft products as well? The exporter is
   currently exporting only published products…

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

The topic ‘Importer issues’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

## Tags

 * [csv](https://wordpress.org/support/topic-tag/csv/)
 * [export](https://wordpress.org/support/topic-tag/export/)
 * [product import](https://wordpress.org/support/topic-tag/product-import/)

 * 5 replies
 * 2 participants
 * Last reply from: [nemanja09](https://wordpress.org/support/users/nemanja09/)
 * Last activity: [8 years, 10 months ago](https://wordpress.org/support/topic/importer-issues/#post-9353502)
 * Status: not resolved