Importing visible attributes with the built in importer

  • Resolved Mario Beach

    (@mariobeach)


    3 years, 4 months ago

    Hi,

    I created a csv file containing 3 types of products, simple, variable, and variation. The new built-in importer supports both variations and products in the same file. The only variation I have is on Size. All works fine except that the variations are not linked using the attribute and I need to go in each product to select the size of my variations manually which makes no sense. It seems the the meta value “attribute_pa_size” does not get created when importing in the “Attribute” & “Attribute Value”. I even tried importing my variations separately using the meta value “attribute_pa_size” but it still won’t import. All my attributes are global and already created. 

    My values are for example:
product_type | Attribute Name | Attribute Value(s) | 
variable     |  Size          | 30ml, 200ml, 400ml
variation    |  Size          | 30ml
variation    |  Size          | 200ml
variation    |  Size          | 400ml

    My variations will be created, attached to the parent product but in the backend I need to select [30ml] in the Size dropdown of my variation. I’m out of options, any idea what I’m doing wrong.

    Thank you

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

  • Hello,

    Can you share the following so we can take a look?

    – The CSV you are trying to import: You can use an online fileshare like file.io, Google Drive, DropBox, etc.

    – 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.

    Thread Starter Mario Beach

    (@mariobeach)

    Here’s the original file I was trying to import with the new built in importer.
    https://www.dropbox.com/s/eoj3v07bfbp631o/pureology_woo_FR.csv?dl=0

    The Size attribute is called “Taille” because it’s in French.
    Like I said it almost worked perfectly except for that attribute meta value missing.

    In the meantime I installed the old CSV Import Suite and was able to fix my variations using a separate variations only file but I really liked the idea we could now import using one file!!

    When looking in post_meta I noticed the following:

    The attribute value should have been store in meta_key “attribute_pa_taille” in plain text but instead the built-in importer created this key: “attributes:value1” and stored the value in json. I also had another key created “attributes:valueattributes:valueattribute_pa_taille” with the same json value most likely from my attempt to import as meta value instead of attribute value.

    System Report:

    
### WordPress Environment ###

WordPress address (URL): https://hx6.47f.myftpupload.com
Site address (URL): https://hx6.47f.myftpupload.com
WC Version: 5.4.1
REST API Version: ? 5.4.1
WC Blocks Version: ? 5.1.0
Action Scheduler Version: ? 3.1.6
WC Admin Version: ? 2.3.1
Log Directory Writable: ?
WP Version: 5.7.2
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: fr_CA
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.3.12
PHP Post Max Size: 100 MB
PHP Time Limit: 300
PHP Max Input Vars: 1000
cURL Version: 7.45.0
OpenSSL/1.0.1e

SUHOSIN Installed: –
MySQL Version: 5.7.26-29-log
Max Upload Size: 100 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 5.4.1
WC Database Prefix: wp_ycg3ma4gg2_
Total Database Size: 22.13MB
Database Data Size: 19.74MB
Database Index Size: 2.39MB
wp_ycg3ma4gg2_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ycg3ma4gg2_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_ycg3ma4gg2_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ycg3ma4gg2_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_ycg3ma4gg2_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ycg3ma4gg2_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_ycg3ma4gg2_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_ycg3ma4gg2_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_ycg3ma4gg2_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ycg3ma4gg2_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_ycg3ma4gg2_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ycg3ma4gg2_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ycg3ma4gg2_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_ycg3ma4gg2_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ycg3ma4gg2_actionscheduler_actions: Data: 0.23MB + Index: 0.25MB + Engine InnoDB
wp_ycg3ma4gg2_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ycg3ma4gg2_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ycg3ma4gg2_actionscheduler_logs: Data: 0.17MB + Index: 0.16MB + Engine InnoDB
wp_ycg3ma4gg2_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_ycg3ma4gg2_comments: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
wp_ycg3ma4gg2_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ycg3ma4gg2_options: Data: 4.22MB + Index: 0.08MB + Engine InnoDB
wp_ycg3ma4gg2_postmeta: Data: 1.45MB + Index: 0.33MB + Engine InnoDB
wp_ycg3ma4gg2_posts: Data: 12.09MB + Index: 0.13MB + Engine InnoDB
wp_ycg3ma4gg2_sbi_instagram_feeds_posts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_ycg3ma4gg2_sbi_instagram_feed_locator: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_ycg3ma4gg2_sbi_instagram_posts: Data: 0.30MB + Index: 0.00MB + Engine InnoDB
wp_ycg3ma4gg2_sm_advanced_search_temp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ycg3ma4gg2_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_ycg3ma4gg2_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_ycg3ma4gg2_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ycg3ma4gg2_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_ycg3ma4gg2_usermeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_ycg3ma4gg2_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_ycg3ma4gg2_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ycg3ma4gg2_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ycg3ma4gg2_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ycg3ma4gg2_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_ycg3ma4gg2_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_ycg3ma4gg2_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_ycg3ma4gg2_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_ycg3ma4gg2_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_ycg3ma4gg2_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_ycg3ma4gg2_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_ycg3ma4gg2_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ycg3ma4gg2_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ycg3ma4gg2_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ycg3ma4gg2_yoast_indexable: Data: 0.22MB + Index: 0.11MB + Engine InnoDB
wp_ycg3ma4gg2_yoast_indexable_hierarchy: Data: 0.05MB + Index: 0.05MB + Engine InnoDB
wp_ycg3ma4gg2_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ycg3ma4gg2_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_ycg3ma4gg2_yoast_seo_links: Data: 0.06MB + Index: 0.03MB + Engine InnoDB

### Post Type Counts ###

attachment: 245
custom_css: 2
et_footer_layout: 1
et_header_layout: 1
et_pb_layout: 2
et_template: 2
et_theme_builder: 1
nav_menu_item: 5
oembed_cache: 1
page: 9
post: 3
product: 32
product_variation: 68
revision: 315

### Security ###

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

### Active Plugins (10) ###

Better Search Replace: by Delicious Brains – 1.3.4
Classic Editor: by WordPress Contributors – 1.6
GA Google Analytics: by Jeff Starr – 20210211
Smash Balloon Instagram Feed: by Smash Balloon – 2.9.1
Smart Manager For WooCommerce – Stock Management, Bulk Edit & more...: by StoreApps – 5.18.0
Sucuri Security - Auditing, Malware Scanner and Hardening: by Sucuri Inc. – 1.8.26
WooCommerce Global Payments HPP: by SkyVerge – 3.0.0
WooCommerce Product CSV Import Suite: by WooCommerce – 1.10.41
WooCommerce: by Automattic – 5.4.1
Yoast SEO: by Team Yoast – 16.5

### Inactive Plugins (14) ###

Akismet Anti-Spam: by Automattic – 4.1.9
All-in-One WP Migration: by ServMask – 7.44
All-in-One WP Migration Unlimited Extension: by ServMask – 2.37
CoBlocks: by GoDaddy – 2.12.1
Divi Builder: by Elegant Themes – 4.9.4
Facebook for WooCommerce: by Facebook – 2.6.0
Follow-Up Emails: by WooCommerce – 4.9.13
Gravity Forms: by Gravity Forms – 2.5.1
Hello Dolly: by Matt Mullenweg – 1.7.2
WooCommerce Canada Post Shipping: by WooCommerce – 2.5.19
WooCommerce Checkout Field Editor: by WooCommerce – 1.6.1
WooCommerce Email Customizer: by WooCommerce – 1.2.0
WooCommerce Shipping & Tax: by WooCommerce – 1.25.14
WP101 Video Tutorials: by WP101Plugin.com – 0.3

### Must Use Plugins (1) ###

System Plugin: by  – 4.6.6

### Settings ###

API Enabled: –
Force SSL: ?
Currency: CAD ($)
Currency Position: right
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: #67 - /boutique/
Cart: #747 - /panier/
Checkout: #748 - /commande/
My account: #749 - /mon-compte/
Terms and conditions: ? Page not set

### Theme ###

Name: Divi
Version: 4.9.4
Author URL: https://www.elegantthemes.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: –

### Action Scheduler ###

Complete: 723
Oldest: 2021-06-10 14:35:11 +0000
Newest: 2021-06-29 02:10:49 +0000

### Status report information ###

Generated at: 2021-06-29 02:23:30 +00:00

    Hello,

    Thank you for sharing the System Status and CSV file. OK, if you are using the built-in CSV importer exporter, you’d need to follow its own CSV format: https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Import-Schema#csv-columns-and-formatting

    The best way to do this is exporting existing variable products that are working properly, change the value, and import it back to your store.
    For more information, please refer to our documentation: https://docs.woocommerce.com/document/product-csv-importer-exporter/

    Hi @mariobeach

    We’ve not heard back from you in a while, so I’m marking this thread as resolved. If you have further questions, please feel free to open a new topic.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Importing visible attributes with the built in importer’ is closed to new replies.