Attributes not showing after importing CSV file
-
Hi, I have been trying to import some csv spreadsheets to a new store and am having problems with the attributes. They show on the front end of the site and also when I go to the edit product page, however if I click on attributes in the main products menu they are not there. Any suggestions why this might be please?
Uploaded a copy of the csv here if it helps https://arbtalkmedia.co.uk/wp-content/uploads/2020/09/Coast-Matt-Final-MK.csv
-
Hey there!
Could you please share 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.### WordPress Environment ### WordPress address (URL): https://eastcoastpaint.co.uk Site address (URL): https://eastcoastpaint.co.uk WC Version: 4.1.1 REST API Version: ? 1.0.7 WC Blocks Version: ? 2.5.16 Action Scheduler Version: ? 3.1.6 WC Admin Version: ? 1.1.3 Log Directory Writable: ? WP Version: ? 5.5 - There is a newer version of WordPress available (5.5.1) 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.4.9 PHP Post Max Size: 128 MB PHP Time Limit: 300 PHP Max Input Vars: 2500 cURL Version: 7.65.0 OpenSSL/1.0.2k-fips SUHOSIN Installed: – MySQL Version: 5.5.5-10.2.33-MariaDB-log Max Upload Size: 128 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? ### Database ### WC Database Version: 3.8.1 WC Database Prefix: wp_ Total Database Size: 42.96MB Database Data Size: 30.49MB Database Index Size: 12.47MB 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: 0.02MB + Index: 0.11MB + 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.02MB + Index: 0.03MB + Engine InnoDB wp_cartflows_ca_cart_abandonment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_cartflows_ca_email_history: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_cartflows_ca_email_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_cartflows_ca_email_templates_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_options: Data: 4.34MB + Index: 0.27MB + Engine InnoDB wp_postmeta: Data: 16.13MB + Index: 8.20MB + Engine InnoDB wp_posts: Data: 7.08MB + Index: 1.06MB + Engine InnoDB wp_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_termmeta: Data: 0.09MB + Index: 0.11MB + Engine InnoDB wp_terms: Data: 0.06MB + Index: 0.03MB + Engine InnoDB wp_term_relationships: Data: 0.36MB + Index: 0.28MB + Engine InnoDB wp_term_taxonomy: Data: 0.08MB + Index: 0.11MB + Engine InnoDB wp_usermeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wc_admin_notes: Data: 0.02MB + 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_meta_lookup: Data: 1.52MB + Index: 1.25MB + 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 ### Post Type Counts ### astra-advanced-hook: 1 attachment: 576 custom_css: 4 customize_changeset: 3 elementor_library: 4 elementor-hf: 3 nav_menu_item: 173 oembed_cache: 13 page: 16 post: 5 product: 1555 product_variation: 2890 revision: 284 shop_order: 6 wpcf7_contact_form: 2 wpforms: 1 ### Security ### Secure connection (HTTPS): ? Hide errors from visitors: ? ### Active Plugins (23) ### Astra Pro: by Brainstorm Force – 2.5.0 Premium Starter Templates: by Brainstorm Force – 2.2.4 Better Search Replace: by Delicious Brains – 1.3.3 Coast Paint Customization Addon: by Vikas Sharma – 0.0.1 Coming Soon Page, Under Construction & Maintenance Mode by SeedProd: by SeedProd – 5.1.2 Contact Form 7: by Takayuki Miyoshi – 5.1.9 Custom Fonts: by Brainstorm Force – 1.2.1 Customizer Export/Import: by The Beaver Builder Team – 0.9.1 Duplicate Page: by mndpsingh287 – 4.2 Elementor Pro: by Elementor.com – 2.9.5 Elementor: by Elementor.com – 2.9.9 Elementor - Header, Footer & Blocks: by Brainstorm Force Nikhil Chavan – 1.5.0 Smart WooCommerce Search: by YummyWP – 1.5.18 Ultimate Addons for Elementor: by Brainstorm Force – 1.24.3 UpdraftPlus - Backup/Restore: by UpdraftPlus.Com DavidAnderson – 2.16.26.24 WooCommerce Cart Abandonment Recovery: by CartFlows Inc – 1.2.6 WooCommerce Stripe Gateway: by WooCommerce – 4.4.0 – Installed version not tested with active version of WooCommerce 4.1.1 WooCommerce WorldPay Gateway: by Andrew Benbow – 4.1.3 – Installed version not tested with active version of WooCommerce 4.1.1 WooCommerce: by Automattic – 4.1.1 (update to version 4.4.1 is available) Smush Pro: by WPMU DEV – 3.4.2 WPForms Lite: by WPForms – 1.6.0.2 WPMU DEV Dashboard: by WPMU DEV – 4.10.1 WPvivid Backup Plugin: by WPvivid Team – 0.9.42 ### Inactive Plugins (0) ### ### Must Use Plugins (1) ### StackCache: by Stack CP – ### 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: #36 - /shop/ Basket: #38 - /shop/cart/ Checkout: #7 - /checkout/ My account: #42 - /shop/my-account/ Terms and conditions: ? Page not set ### Theme ### Name: Arbtalk Media Ltd Version: 1.0.0 Author URL: https://wpastra.com/about/ Child Theme: ? Parent Theme Name: Astra Parent Theme Version: 2.4.4 – 2.5.4 is available Parent Theme Author URL: https://wpastra.com/about/ WooCommerce Support: ? ### Templates ### Overrides: – ### Action Scheduler ### Complete: 31 Oldest: 2020-08-11 11:44:41 +0100 Newest: 2020-09-02 13:36:39 +0100 Pending: 1 Oldest: 2020-09-03 13:36:39 +0100 Newest: 2020-09-03 13:36:39 +0100
Hi again – can you please update WooCommerce to its latest version, and let us know if that has improved the situation?
Updated everything and tried again, still not working. Did you have a chance to check the spreadsheet was as it should be? I believe it is all correct.
Try with a ‘1’ in the the Variable product row for Attribute 1 visible, Attribute 1 global, Attribute 2 visible and Attribute 2 global?
Thanks ever so much Sean, thats what was missing.
Thank you for getting back to us and confirming what the issue was.
I’ll mark this thread as resolved now. If you have any further questions, I recommend creating a new thread.
- The topic ‘Attributes not showing after importing CSV file’ is closed to new replies.