Title: csv import challenge Last modified: July 10, 2020 --- # csv import challenge * Resolved [Paul](https://wordpress.org/support/users/paulnieman/) * (@paulnieman) * [5 years, 10 months ago](https://wordpress.org/support/topic/csv-import-challenge/) * Importing csv data Variable products each with 2 variations assigned: 1) Postal 2) Digital Download * I have (almost) successfully uploaded Variables and Variations. However there seem to be 5 fields in the csv variable data which get ignored. I have run the csv import process a few times. * These are the fields that don’t get taken up. Attribute 1 name = Delivery Attribute 1 values = Digital download, Postal Attribute 1 visible = 1 Attribute 1 global = 1 Attribute 1 default = Postal * URL for csv of variables [http://edition-zefiro.com/csvuploads/EML-variables.csv](http://edition-zefiro.com/csvuploads/EML-variables.csv) * URL for additional csv of variations separated into 2: Downloads and Postal [http://edition-zefiro.com/csvuploads/](http://edition-zefiro.com/csvuploads/) * Any suggestions? Thank you. * System Status Report Friday, July 10, 2020 * ``` ### WordPress Environment ### WordPress address (URL): https://edition-zefiro.com Site address (URL): https://edition-zefiro.com WC Version: 4.3.0 REST API Version: ✔ 1.0.10 WC Blocks Version: ✔ 2.7.1 Action Scheduler Version: ✔ 3.1.6 WC Admin Version: ✔ 1.3.0 Log Directory Writable: ✔ WP Version: 5.4.2 WP Multisite: – WP Memory Limit: 256 MB WP Debug Mode: – WP Cron: ✔ Language: en_GB External object cache: ✔ ### Server Environment ### Server Info: Apache PHP Version: 7.3.19 PHP Post Max Size: 260 MB PHP Time Limit: 600 PHP Max Input Vars: 1000 cURL Version: 7.71.0 OpenSSL/1.1.1g SUHOSIN Installed: – MySQL Version: 5.6.41-84.1 Max Upload Size: 256 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ ### Database ### WC Database Version: 4.3.0 WC Database Prefix: wp_ Total Database Size: 75.83MB Database Data Size: 64.57MB Database Index Size: 11.26MB wp_woocommerce_sessions: Data: 2.46MB + Index: 0.13MB + Engine MyISAM wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_order_itemmeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_actionscheduler_actions: Data: 1.89MB + Index: 0.69MB + Engine MyISAM wp_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_actionscheduler_logs: Data: 1.12MB + Index: 0.81MB + Engine MyISAM wp_commentmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_comments: Data: 0.36MB + Index: 0.27MB + Engine MyISAM wp_eg_grids: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_eg_item_elements: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_eg_item_skins: Data: 0.12MB + Index: 0.01MB + Engine MyISAM wp_eg_navigation_skins: Data: 0.03MB + Index: 0.01MB + Engine MyISAM wp_failed_jobs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_layerslider: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_layerslider_revisions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailchimp_carts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailchimp_jobs: Data: 0.20MB + Index: 0.01MB + Engine MyISAM wp_options: Data: 43.95MB + Index: 3.96MB + Engine MyISAM wp_postmeta: Data: 7.40MB + Index: 2.59MB + Engine MyISAM wp_posts: Data: 3.06MB + Index: 0.47MB + Engine MyISAM wp_queue: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_revslider_css: Data: 0.09MB + Index: 0.00MB + Engine MyISAM wp_revslider_css_bkp: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wp_revslider_layer_animations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_revslider_layer_animations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_revslider_navigations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_revslider_navigations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_revslider_sliders: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wp_revslider_sliders_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_revslider_slides: Data: 0.07MB + Index: 0.00MB + Engine MyISAM wp_revslider_slides_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_revslider_static_slides: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_revslider_static_slides_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_smush_dir_images: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_socialsnap_stats: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_termmeta: Data: 0.03MB + Index: 0.03MB + Engine MyISAM wp_terms: Data: 0.02MB + Index: 0.03MB + Engine MyISAM wp_term_relationships: Data: 0.16MB + Index: 0.38MB + Engine MyISAM wp_term_taxonomy: Data: 0.02MB + Index: 0.02MB + Engine MyISAM wp_usermeta: Data: 0.39MB + Index: 0.04MB + Engine MyISAM wp_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_w3tc_cdn_pathmap: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_w3tc_cdn_queue: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_admin_notes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_admin_note_actions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_customer_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_order_product_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_wc_order_stats: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_product_meta_lookup: Data: 0.55MB + Index: 0.83MB + Engine MyISAM wp_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wpforms_tasks_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_yoast_indexable: Data: 2.36MB + Index: 0.71MB + Engine MyISAM wp_yoast_indexable_hierarchy: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_yoast_migrations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_yoast_primary_term: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_yoast_seo_links: Data: 0.11MB + Index: 0.02MB + Engine MyISAM wp_yoast_seo_meta: Data: 0.15MB + Index: 0.15MB + Engine MyISAM ### Post Type Counts ### attachment: 784 customize_changeset: 13 jetpack_migration: 2 jp_img_sitemap: 2 jp_sitemap: 2 jp_sitemap_master: 2 nav_menu_item: 121 oembed_cache: 1 page: 24 post: 8 product: 547 product_variation: 1100 revision: 162 shop_order: 10 vc_grid_item: 1 wp_block: 4 wpcf7_contact_form: 2 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (22) ### LayerSlider WP: by Kreatura Media – 6.11.1 Akismet Anti-Spam: by Automattic – 4.1.6 Contact Form 7: by Takayuki Miyoshi – 5.2 Essential Grid: by ThemePunch – 2.3.6 Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 7.11.0 Jetpack by WordPress.com: by Automattic – 8.7 WPBakery Page Builder: by Michael M - WPBakery.com – 6.2.0 Mailchimp for WooCommerce: by Mailchimp – 2.4.1 – Installed version not tested with active version of WooCommerce 4.3.0 Slider Revolution: by ThemePunch – 6.2.15 Social Snap Lite: by Social Snap LLC – 1.1.8.3 UpdraftPlus - Backup/Restore: by UpdraftPlus.Com DavidAnderson – 1.16.26 W3 Total Cache: by BoldGrid – 0.14.2 WooCommerce Admin: by WooCommerce – 1.3.0 – Installed version not tested with active version of WooCommerce 4.3.0 WooCommerce PayPal Checkout Gateway: by WooCommerce – 2.0.3 WooCommerce PayPal Powered by Braintree Gateway: by WooCommerce – 2.3.11 – Installed version not tested with active version of WooCommerce 4.3.0 WooCommerce Services: by Automattic – 1.23.2 – Installed version not tested with active version of WooCommerce 4.3.0 WooCommerce - ShipStation Integration: by WooCommerce – 4.1.37 – Installed version not tested with active version of WooCommerce 4.3.0 WooCommerce: by Automattic – 4.3.0 WordPress Importer: by wordpressdotorg – 0.7 Yoast SEO: by Team Yoast – 14.5 – Installed version not tested with active version of WooCommerce 4.3.0 Smush: by WPMU DEV – 3.6.3 WPForms Lite: by WPForms – 1.6.1 ### Inactive Plugins (0) ### ### Dropin Plugins (3) ### advanced-cache.php: advanced-cache.php db.php: db.php object-cache.php: object-cache.php ### Must Use Plugins (1) ### Endurance Page Cache: by Mike Hansen – 2.0 ### 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: – ### WC Pages ### Shop base: #9 - /index.php/shop/ Basket: #2199 - /index.php/cart/ Checkout: #2201 - /index.php/checkout-2/ My account: #2203 - /index.php/my-account-2/ Terms and conditions: #217 - /index.php/terms-and-conditions/ ### Theme ### Name: Highend Version: 3.6.6.1 Author URL: https://hb-themes.com Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme WooCommerce Support: ✔ ### Templates ### Overrides: HighendWP/woocommerce/cart/cart-empty.php HighendWP/woocommerce/cart/cart-totals.php HighendWP/woocommerce/cart/cart.php HighendWP/woocommerce/cart/shipping-calculator.php HighendWP/woocommerce/checkout/form-billing.php HighendWP/woocommerce/checkout/form-checkout.php HighendWP/woocommerce/checkout/form-shipping.php HighendWP/woocommerce/checkout/thankyou.php HighendWP/woocommerce/content-product.php HighendWP/woocommerce/content-product_cat.php HighendWP/woocommerce/global/quantity-input.php HighendWP/woocommerce/loop/add-to-cart.php HighendWP/woocommerce/loop/loop-end.php HighendWP/woocommerce/loop/loop-start.php HighendWP/woocommerce/loop/orderby.php HighendWP/woocommerce/loop/rating.php HighendWP/woocommerce/myaccount/my-address.php HighendWP/woocommerce/single-product/meta.php HighendWP/woocommerce/single-product/related.php HighendWP/woocommerce/single-product/sale-flash.php HighendWP/woocommerce/single-product/short-description.php HighendWP/woocommerce/single-product/tabs/additional-information.php HighendWP/woocommerce/single-product/tabs/description.php HighendWP/woocommerce/single-product/title.php HighendWP/woocommerce/single-product/up-sells.php HighendWP/woocommerce/single-product-reviews.php ### Action Scheduler ### Complete: 6,353 Oldest: 2020-06-24 08:59:27 +0000 Newest: 2020-07-10 11:16:33 +0000 Pending: 4 Oldest: 2020-07-10 12:16:33 +0000 Newest: 2020-07-11 10:24:16 +0000 ``` * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fcsv-import-challenge%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 2 replies - 1 through 2 (of 2 total) * Plugin Support [Fernando a11n](https://wordpress.org/support/users/fhaps/) * (@fhaps) * Automattic Happiness Engineer * [5 years, 10 months ago](https://wordpress.org/support/topic/csv-import-challenge/#post-13106504) * The column header names are different than what is expected by default in the import process. You’ll need to make sure that they are being mapped to the correct field after the file is uploaded. * These are the titles that the plugin expects by default: * > Attribute 1 name > Attribute 1 value(s) Attribute 1 visible Attribute 1 global * These are the ones in your CSV file: * > Attribute name > Attribute value(s) Attribute visiblity Is a global attribute? * Try reviewing all the column titles and re-import once fixed. If you want to make sure the formatting is correct on all of them, I’d recommend creating a variable product manually through the dashboard, and then exporting the file to verify how the plugin formats it. * Thread Starter [Paul](https://wordpress.org/support/users/paulnieman/) * (@paulnieman) * [5 years, 10 months ago](https://wordpress.org/support/topic/csv-import-challenge/#post-13107444) * Fernando thankyou x 100 It seems so simple and obvious once it has been explained. You are truly a Happiness Engineer! Paul Viewing 2 replies - 1 through 2 (of 2 total) The topic ‘csv import challenge’ 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/) * [Import](https://wordpress.org/support/topic-tag/import/) * [variables](https://wordpress.org/support/topic-tag/variables/) * 2 replies * 2 participants * Last reply from: [Paul](https://wordpress.org/support/users/paulnieman/) * Last activity: [5 years, 10 months ago](https://wordpress.org/support/topic/csv-import-challenge/#post-13107444) * Status: resolved