Import delimiter not being honored

Hi @martinhughestopline

I understand that the pipe delimiter on your CSV is being ignored while importing.

It is unclear why it is happening – normally it is supposed to work if pipe is chosen for the delimiter.

Link to image: https://snipboard.io/26elNv.jpg

The first thing I recommend doing is to review our documentation on importing products:
https://docs.woocommerce.com/document/product-csv-importer-exporter/

That support page has a link to a blank, formatted CSV that can be used to build a workable import file. Another option is to configure one product in the store for each type of product (simple, variable, virtual, downloadable) and export that single product to a CSV. That will provide a CSV template unique to your store and can be used by adding the information for the rest of the products to the CSV. This can then be used to Import the remaining products. I hope that helps.

• This reply was modified 2 years, 4 months ago by Margaret S. woo-hc.

Hi, thank you for the reply.

I understand how it should work but it does not.

As a test, i used the following code to change the export delimiter to a pipe:

add_filter( 'woocommerce_product_export_delimiter', function ( $delimiter ) {

	// set your custom delimiter
	$delimiter = '|';

	return $delimiter;
} );

i then exported all of my test products that i have on the site and reimported this same file (without editing it) back into woocommerce but even this does not acknowledge the pipe delimiter.

any ideas?

Hello @martinhughestopline!

Thanks for the reply!

I understand how it should work but it does not.

Could you please let us know if you are using the default product import tool or an extension like Product CSV Import Suite?

Additionally, please give us more insight by sharing a copy of your site’s System Status. You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”.? Once you’ve done that, paste it here in your response.

A copy of any fatal errors found under WooCommerce→Status→Logs would also be helpful.

We will be waiting for your response!

Hi,

I am using the default WooCommerce importer.

here is the Woo report and there was no fatal error logs.

### WordPress Environment ###

WordPress address (URL): https://www.925jewellery.co.uk
Site address (URL): https://www.925jewellery.co.uk
WC Version: 6.7.0
REST API Version: ? 6.7.0
WC Blocks Version: ? 7.8.3
Action Scheduler Version: ? 3.4.0
Log Directory Writable: ?
WP Version: 6.0.1
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_GB
External object cache: –

### Server Environment ###

Server Info: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips mod_fcgid/2.3.9
PHP Version: 7.2.24
PHP Post Max Size: 8 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.29.0
NSS/3.53.1

SUHOSIN Installed: –
MySQL Version: 5.5.68-MariaDB
Max Upload Size: 2 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ? Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 6.7.0
WC Database Prefix: wp_
Total Database Size: 24.69MB
Database Data Size: 16.31MB
Database Index Size: 8.38MB
wp_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Data: 1.52MB + Index: 0.81MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 0.38MB + Index: 0.25MB + Engine InnoDB
wp_berocket_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_gla_budget_recommendations: Data: 0.22MB + Index: 0.14MB + Engine InnoDB
wp_gla_merchant_issues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_gla_shipping_rates: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 6.14MB + Index: 0.16MB + Engine InnoDB
wp_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_hash: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_imports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_postmeta: Data: 3.52MB + Index: 4.03MB + Engine InnoDB
wp_posts: Data: 1.52MB + Index: 0.50MB + Engine InnoDB
wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 0.14MB + Index: 0.13MB + Engine InnoDB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_usermeta: Data: 0.08MB + Index: 0.03MB + Engine InnoDB
wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.16MB + Index: 0.36MB + Engine InnoDB
wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_yoast_indexable: Data: 1.52MB + Index: 0.73MB + Engine InnoDB
wp_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_yoast_seo_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

### Post Type Counts ###

attachment: 713
br_product_filter: 1
bsf-sidebar: 1
custom_css: 1
customize_changeset: 67
nav_menu_item: 23
page: 12
post: 17
product: 1075
product_variation: 134
revision: 1
wp_global_styles: 1
wpforms: 2
wwp_requests: 2
yith_wcan_preset: 2

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (13) ###

All-in-One WP Migration File Extension: by ServMask
Inc. – 1.8

All-in-One WP Migration: by ServMask – 7.62
Astra Pro: by Brainstorm Force – 3.6.11
File Manager Advanced: by modalweb – 4.1.5
Speed Booster Pack: by Optimocha – 4.5.5
Ultimate Addons for Gutenberg: by Brainstorm Force – 1.25.6
WooCommerce Payments: by Automattic – 4.4.0
WooCommerce Shipping & Tax: by WooCommerce – 1.26.2
Wholesale For WooCommerce: by wpexpertsio – 2.0.1
WooCommerce: by Automattic – 6.7.0
Yoast SEO: by Team Yoast – 19.3
WPForms Lite: by WPForms – 1.7.5.3
YITH WooCommerce Ajax Product Filter: by YITH – 4.12.0

### Inactive Plugins (4) ###

Back In Stock Notifier for WooCommerce | WooCommerce Waitlist Pro: by codewoogeek – 3.0
Sidebar Manager: by Brainstorm Force – 1.1.7
WOOEXIM - WooCommerce Export Import Plugin: by WOOEXIM.COM – 5.0.0
WP Mail SMTP: by WPForms – 3.5.1

### Settings ###

API Enabled: –
Force SSL: –
Currency: GBP (￡)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

Connected to WooCommerce.com: –
Enforce Approved Product Download Directories: ?

### WC Pages ###

Shop base: #6 - /shop/
Basket: #7 - /basket/
Checkout: #8 - /checkout/
My account: #9 - /my-account/
Terms and conditions: ? Page not set

### Theme ###

Name: 925jewellery
Version: 1.0.0
Author URL: https://www.topline.co.uk
Child Theme: ?
Parent Theme Name: Astra
Parent Theme Version: 3.8.5
Parent Theme Author URL: https://wpastra.com/about/?utm_source=theme_preview&utm_medium=author_link&utm_campaign=astra_theme
WooCommerce Support: ?

### Templates ###

Overrides: 925jewellery/woocommerce/cart/mini-cart.php

### Admin ###

Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
experimental-products-task
experimental-import-products-task
experimental-fashion-sample-products
experimental-product-tour
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
wc-pay-promotion
wc-pay-welcome-page
wc-pay-subscriptions-page

Disabled Features: minified-js
settings

Daily Cron: ? Next scheduled: 2022-07-12 12:09:01 +01:00
Options: ?
Notes: 55
Onboarding: completed

### WooCommerce Payments ###

Version: 4.4.0
Connected to WPCOM: No
Blog ID: -
Account ID: -

### Action Scheduler ###

Complete: 1,075
Oldest: 2022-06-24 10:16:54 +0100
Newest: 2022-07-19 15:09:38 +0100

Pending: 1,262
Oldest: 2022-07-19 15:26:39 +0100
Newest: 2022-07-21 15:57:03 +0100

### Status report information ###

Generated at: 2022-07-20 13:47:32 +01:00

Hey @martinhughestopline

Thank you for sharing the system status report.

PHP Post Max Size: 8 MB

I would suggest asking your host to increase this limit, check this documentation

If this does not help, I would recommend you also share with us the CSV, this way we can test it on our end.

Thanks!

Hi,
Post max size is not the issue as the sample size is i have tried is between 1 and 3 products.

When i did some formatting on a 1000 product test, it imported all of them but of course that required alot of faffing to get it to import.

here is a test export with the | pipe delimiter that wont import:
https://pastebin.com/wUusJkhs

Hello!

I was checking the code you provided earlier and it is working for me, the file delimiter is indeed |.

Link to image: https://snipboard.io/aodlyT.jpg

May I ask how are you creating the file? Please provide more details. I am wondering if there is some type of format issue.

Hi @martinhughestopline

I mean when creating the file using the code snippet are you opening the file using any Spreadsheet tool, then upload to your site? When importing the CSV file delimited by | are you able to see the import log? If you change the file back to comma delimiter, is the file imported correctly?

Let us know.

• This reply was modified 2 years, 4 months ago by Igor H.

Hi,
The export is being generated via a SQL statement.
If i open it in Excel and then resave the file, it imports correctly but converts the delimiter to commas.

When i try and import this file it doesnt map to any fields and imports it as 1 product but none of the fields are correct.

Hello,

I understand what you are saying. You can try the following steps:

• Temporarily switch your theme to Storefront
• Disable all plugins except for WooCommerce
• Try again to import the file

Check if the file format (separated by “|”) is recognized, and check if the import runs. If that worked you can ten reactivate the theme and plugins one by one until you find the culprit. You can find a more detailed explanation on how to do a conflict test here.

Let us know if this makes a difference.