Support » Plugin: WooCommerce » [Bug] Attributes Not Getting Imported in CSV Product Importer

  • divijc

    (@divijc)


    Hi, In Woocommerce 3.1 CSV Importer, Product attributes are not getting imported. Please provide a solution.

    
    ### WordPress Environment ###
    
    Home URL: https://www.yourprint.in
    Site URL: https://www.yourprint.in
    WC Version: 3.1.0
    Log Directory Writable: ✔
    WP Version: 4.8
    WP Multisite: –
    WP Memory Limit: 324 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_US
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: ❌ 5.5.9-1ubuntu4.21 - We recommend a minimum PHP version of 5.6. See: How to update your PHP version
    PHP Post Max Size: 8 MB
    PHP Time Limit: 0
    PHP Max Input Vars: 1000
    cURL Version: 7.35.0
    OpenSSL/1.0.1f
    
    SUHOSIN Installed: ✔
    MySQL Version: ❌ 5.5.55 - We recommend a minimum MySQL version of 5.6. See: WordPress requirements
    Max Upload Size: 8 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 3.1.0
    WC Database Prefix: wp_
    woocommerce_sessions: ✔
    woocommerce_api_keys: ✔
    woocommerce_attribute_taxonomies: ✔
    woocommerce_downloadable_product_permissions: ✔
    woocommerce_order_items: ✔
    woocommerce_order_itemmeta: ✔
    woocommerce_tax_rates: ✔
    woocommerce_tax_rate_locations: ✔
    woocommerce_shipping_zones: ✔
    woocommerce_shipping_zone_locations: ✔
    woocommerce_shipping_zone_methods: ✔
    woocommerce_payment_tokens: ✔
    woocommerce_payment_tokenmeta: ✔
    MaxMind GeoIP Database: ❌ The MaxMind GeoIP Database does not exist - Geolocation will not function. You can download and install it manually from http://dev.maxmind.com/geoip/legacy/geolite/ to the path: . Scroll down to "Downloads" and download the "Binary / gzip" file next to "GeoLite Country". Please remember to uncompress GeoIP.dat.gz and upload the GeoIP.dat file only.
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (27) ###
    
    BackUpWordPress: by Human Made Limited – 3.6.4
    Better Search Replace: by Delicious Brains – 1.3
    Contact Form 7: by Takayuki Miyoshi – 4.8
    Easy Google Fonts: by Titanium Themes – 1.4.2
    Easy WP SMTP: by wpecommerce – 1.2.5
    Fancy Product Designer: by Rafael Dery | radykal.de – 3.4.6
    Hide This: by Andrés Villarreal – 1.1.3
    Nextend Facebook Connect: by Nextendweb – 2.0.2
    Peter's Login Redirect: by Peter Keung – 2.9.1
    Popup Maker: by WP Popup Maker – 1.6.0
    PW WooCommerce Bulk Edit: by Pimwick
    LLC – 2.25
    
    Really Simple SSL: by Rogier Lankhorst – 2.5.17
    Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 2.2.6
    TablePress: by Tobias Bäthge – 1.8
    Category Order and Taxonomy Terms Order: by Nsp-Code – 1.5
    User Role Editor: by Vladimir Garagulya – 4.32.3
    WC Fields Factory: by Saravana Kumar K – 1.3.8
    WC Password Strength Settings: by Daniel Santoro – 1.1.0
    Widget Logic: by wpchefgadget
    alanft – 5.8.2
    
    Widget Shortcode: by Hassan Derakhshandeh – 0.3.0
    Woo Login Redirect: by Nayem – 1.1
    WooCommerce Razorpay Payments: by Razorpay – 1.4.6
    WooCommerce: by Automattic – 3.1.0
    WooSidebars: by WooThemes – 1.4.3
    Yoast SEO: by Team Yoast – 4.9
    WP Fastest Cache: by Emre Vona – 0.8.7.0
    WP Smush: by WPMU DEV – 2.7.1
    
    ### Settings ###
    
    API Enabled: ✔
    Force SSL: –
    Currency: INR (₹)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    Taxonomies: Product Types: simple (simple)
    grouped (grouped)
    variable (variable)
    external (external)
    
    Taxonomies: Product Visibility: exclude-from-search (exclude-from-search)
    exclude-from-catalog (exclude-from-catalog)
    featured (featured)
    outofstock (outofstock)
    rated-1 (rated-1)
    rated-2 (rated-2)
    rated-3 (rated-3)
    rated-4 (rated-4)
    rated-5 (rated-5)
    
    ### WC Pages ###
    
    Shop base: #4 - /shop/
    Cart: #5 - /cart/
    Checkout: #6 - /checkout/
    My account: #7 - /my-account/
    
    ### Theme ###
    
    Name: Flatsome Child
    Version: 3.0
    Author URL: 
    Child Theme: ✔
    Parent Theme Name: Flatsome
    Parent Theme Version: 3.3.6
    Parent Theme Author URL: http://www.uxthemes.com/
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: flatsome/woocommerce/archive-product.php
    flatsome/woocommerce/cart/cart-empty.php
    flatsome/woocommerce/cart/cart.php
    flatsome/woocommerce/checkout/form-checkout.php
    flatsome/woocommerce/checkout/form-coupon.php
    flatsome/woocommerce/checkout/thankyou.php
    flatsome/woocommerce/content-product.php
    flatsome/woocommerce/content-product_cat.php
    flatsome/woocommerce/content-single-product.php
    flatsome/woocommerce/global/breadcrumb.php
    flatsome/woocommerce/global/quantity-input.php
    flatsome/woocommerce/global/wrapper-end.php
    flatsome/woocommerce/global/wrapper-start.php
    flatsome/woocommerce/loop/loop-end.php
    flatsome/woocommerce/loop/loop-start.php
    flatsome/woocommerce/loop/orderby.php
    flatsome/woocommerce/loop/pagination.php
    flatsome/woocommerce/loop/result-count.php
    flatsome/woocommerce/loop/sale-flash.php
    flatsome/woocommerce/myaccount/form-login.php
    flatsome/woocommerce/myaccount/navigation.php
    flatsome/woocommerce/notices/error.php
    flatsome/woocommerce/notices/notice.php
    flatsome/woocommerce/notices/success.php
    flatsome/woocommerce/product-searchform.php
    flatsome/woocommerce/single-product/photoswipe.php
    flatsome/woocommerce/single-product/price.php
    flatsome/woocommerce/single-product/product-image.php
    flatsome/woocommerce/single-product/product-thumbnails.php
    flatsome/woocommerce/single-product/related.php
    flatsome/woocommerce/single-product/review.php
    flatsome/woocommerce/single-product/sale-flash.php
    flatsome/woocommerce/single-product/share.php
    flatsome/woocommerce/single-product/short-description.php
    flatsome/woocommerce/single-product/tabs/tabs.php
    flatsome/woocommerce/single-product/title.php
    flatsome/woocommerce/single-product/up-sells.php
    flatsome/woocommerce/single-product-reviews.php
    flatsome/woocommerce/single-product.php
    
    
Viewing 15 replies - 1 through 15 (of 36 total)
  • urikanonov

    (@urikanonov)

    Having some issues with *non global* attributes. They’re simply not being set.
    Global attributes however are being set.

    divijc

    (@divijc)

    Global attributes are not being set as well. I am trying to import attributes for simple products but global attributes are also not being set for these.

    urikanonov

    (@urikanonov)

    I had the global attributes manually pre-set, that might be the reason it worked for me

    divijc

    (@divijc)

    Yes, might have been due to that.

    Plugin Author Mike Jolley

    (@mikejolley)

    The only know issue is with CSVs in non-UTF8 format, so try exporting the CSV with this encoding or using a program like openoffice or google docs which does this by default.

    To look further we’d need a CSV anyhow.

    divijc

    (@divijc)

    Hi, I exported the csv with UTF8 encoding but the issue still persists. You can see the csv file here- https://drive.google.com/open?id=0B5qy6NqJR14oaEhMV3ByVFMzMWc

    Plugin Author Mike Jolley

    (@mikejolley)

    This CSV is not valid, it’s missing quotes around each cell for example.

    Imports like this: https://dl.dropboxusercontent.com/s/3vtwuen55fw833i/2017-07-04%20at%2013.42.png

    divijc

    (@divijc)

    Apologies, had shared the wrong sheet, correct sheet exported from google docs can be found here- https://drive.google.com/open?id=0B4EAw0fXE1-zdGhpbDVhdlpucmM

    I imported this to update the attribute of the given sku but the update didn’t happen. Similarly, Attributes for new products are also not getting imported.

    Plugin Author Mike Jolley

    (@mikejolley)

    Does it work with a new product import? I imported this successfully and a global attribute was created.

    divijc

    (@divijc)

    It is neither working with a new product import nor with an existing product import. The attribute is not getting imported in the product. All the other fields like name, stock etc are getting imported. Have tried it in 2 installations – one of them had no external plugins apart from Woocommerce and the default plugins that come with WordPress.

    Plugin Author Mike Jolley

    (@mikejolley)

    Do you have a test install to test master branch? Thats what I imported with, and again, the attribute did not exist and the ‘update product’ checkbox was unchecked.

    divijc

    (@divijc)

    Hi, Yes, I have a test install. Should I share the login details with you?

    Plugin Author Mike Jolley

    (@mikejolley)

    No, just install the master branch from github on the TEST install only and try another import https://github.com/woocommerce/woocommerce/archive/master.zip

    divijc

    (@divijc)

    Hi, I installed the master branch. A global attribute is being created as reported by you but the attribute is not getting added to the product. If an already existing attribute is entered in the sheet, that also is not getting imported in the product.

    Plugin Author Mike Jolley

    (@mikejolley)

    Is the term being created for the global attribute? Have you ruled out a conflict with your installed plugins?

Viewing 15 replies - 1 through 15 (of 36 total)
  • The topic ‘[Bug] Attributes Not Getting Imported in CSV Product Importer’ is closed to new replies.