Support » Plugin: WooCommerce » Updating products via CSV doesn’t work

  • Resolved zurdac

    (@zurdac)


    I’m having problems with the CSV when I try to update products already created. If I import the CSV for new products, it works more or less properly (not sure why there are some products uploaded without category, when I have everything categorized). But when I try to upload a CSV -the same CSV working to upload products- with the “update products if they already exist” activate, it never finishes uploading [example]. It could stay more than 3h like that, more or less, until I close the tab/laptop. Sometimes it advances more or less until half the charge bar, but it never finishes.

    I’ve changed the name of the CSV, and I’ve tried eliminating the columns I don’t need to update on the column’ assignation, but nothing. The CSV is based on the export one the website generated when I started updating the shop, so the column’ names are correct. And I update regularly the WooCommerce version, so I’m working with the last one.

    Thank you so much for your time!

Viewing 15 replies - 1 through 15 (of 16 total)
  • Plugin Support Mirko P.

    (@rainfallnixfig)

    Hi @zurdac,

    If your CSV import gets stuck and causing timeouts you’ll want to look at increasing your server resources. For this, I recommend reaching out to your host support team.

    Be sure to also run a full conflict test to rule out any assumptions that the problem may be caused by a conflict with your theme or plugin. You will find more details here:

    https://docs.woocommerce.com/document/how-to-test-for-conflicts/

    Keep us posted on this!

    Thread Starter zurdac

    (@zurdac)

    Hi @rainfallnixfig,

    Maybe you’re right. I have and old PHP version and I already talked to my technician that is who works with our host service, but he didn’t or couldn’t update that yet. I will talk to him again about this, thank you so much.

    Not so sure about how to run a conflict test properly, but I’m reading the documentation you’ve sent to me and doesn’t look super difficult, so I will try it once I finish uploading products.

    Likewise, I will post again when I have news.

    Thread Starter zurdac

    (@zurdac)

    Hi again!

    I saw here that a solution for slow websites could be dividing the CSV on smaller lists, and it worked! I thought this will be my solution until I get the technician to update the PHP files, but half the products are processed as “no valid” or “duplicate or no valid SKU”, as you can see here. Sincerely, I think it’s a weird error because they’re products that are already active on the website, and I’m just trying to do an updating import (so obviously there are duplicate SKUs, they’re the same product…).

    I will keep trying to solve this, any comment or suggestion is more than welcome.

    Thread Starter zurdac

    (@zurdac)

    Update:

    I got PHP files updated, but I keep getting errors while uploading or updating products. Half the time, some of them don’t have all the information, whatever is just a lack of images or all the information as descriptions and attributes. Without counting the pre-made slug, that I have to change manually on every product even when they’re correctly uploaded.

    If I hadn’t enough with the problems with the products, the website is doing weird things with the grid of the products. I have it to be a five-column grid on the WooCommerce customize menu, but it keeps being a three-column. And I don’t know if it’s because of the demo template that I’m using, or else a problem with the website itself.

    Any kind of suggestions or tips are more than welcome.

    Plugin Support Mirko P.

    (@rainfallnixfig)

    Hi there,

    Thanks for the update!

    Make sure your CSV follows the Product CSV Import Schema and try to import products after disabling all other plugins except WooCommerce and change to a default theme like Storefront.

    Let us know how that goes.

    Thread Starter zurdac

    (@zurdac)

    Hello again, happy to hear about you!

    In the end, I deleted all the products and re-start the import. I keep getting some errors, some a bit weird. Thank you so much for the import schema, because I didn’t know about some properties, and it’s well explained there. Now, the errors.

    1. I had to change manually all the URL/slug of the products. Thankfully they’re not a lot, but I’m worried about what to do in the future, with new products. The property “product_url” is to customize the slug? If so, I understand that should I write there following the pattern I’ve chosen on the web for the URLs?
    2. On the shop archive, some products don’t show their category. Right now, I’ve hidden all the categories on the archive, but the error doesn’t finish there. If you click on one of those products, the URL shows without categories. But if you go to “edit product”, the categories are selected, and they show on the slug.

    Thank you so much again for your help.

    Plugin Support Adam a11n

    (@adamkheckler)

    I had to change manually all the URL/slug of the products. Thankfully they’re not a lot, but I’m worried about what to do in the future, with new products. The property “product_url” is to customize the slug? If so, I understand that should I write there following the pattern I’ve chosen on the web for the URLs?

    I would go by what the example in the schema page shows. So if your site is www.example.com and you want the product slug to be test-product-123, then the product_url column should contain this:

    https://www.example.com/product/test-product-123/

    On the shop archive, some products don’t show their category. Right now, I’ve hidden all the categories on the archive, but the error doesn’t finish there. If you click on one of those products, the URL shows without categories. But if you go to “edit product”, the categories are selected, and they show on the slug.

    Can you send us some screenshots of this? I’m not entirely clear on what you’re referring to by “the URL shows without categories. But if you go to “edit product”, the categories are selected, and they show on the slug.”

    Also, if you could, could you please send me a copy of your site’s system status report? You can find it under WooCommerce > Status in the dashboard. Click “Get system report” and then the “Copy for support” button. Once you’ve done that, paste it into your reply.

    Lastly, sending us the CSV itself may help us find errors faster as well.

    Thanks!

    Thread Starter zurdac

    (@zurdac)

    Hi @adamkheckler, here I am with everything you asked for.

    https://mega.nz/file/baYgHJAS#myRJIAr_20TNrKa9Lr3Ru0bxNf3vt526G4JN0xqqfTU – here is a video about the problem of the categories on the URLs. It’s a bit rusty, but I think you will be able to understand better the issue. Also, there are some products that still shows as importholder*number* on the URL even if I changed them all last week.

    CSV – This is the last version before I split it in three parts. Even if I did that, I still had to check one by one because some of them didn’t import some information like the height and width or the short description.

    And here is the system report.

    
    ### WordPress Environment ###
    
    WordPress address (URL): http://www.elsbanys.es
    Site address (URL): http://www.elsbanys.es
    WC Version: 5.8.0
    REST API Version: ✔ 5.8.0
    WC Blocks Version: ✔ 5.9.1
    Action Scheduler Version: ✔ 3.3.0
    WC Admin Version: ✔ 2.7.2
    Log Directory Writable: ✔
    WP Version: 5.8.1
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: ✔
    WP Cron: ✔
    Language: es_ES
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache/2.4.48 (FreeBSD) OpenSSL/1.1.1k-freebsd
    PHP Version: 7.4.22
    PHP Post Max Size: 90 MB
    PHP Time Limit: 30
    PHP Max Input Vars: 1000
    cURL Version: 7.77.0
    OpenSSL/1.1.1k
    
    SUHOSIN Installed: –
    MySQL Version: 5.7.35-log
    Max Upload Size: 90 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 5.8.0
    WC Database Prefix: wp_
    Tamaño total de la base de datos: 20.16MB
    Tamaño de los datos de la base de datos: 15.58MB
    Tamaño del índice de la base de datos: 4.58MB
    wp_woocommerce_sessions: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
    wp_woocommerce_api_keys: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
    wp_woocommerce_attribute_taxonomies: Datos: 0.00MB + Índice: 0.01MB + Motor MyISAM
    wp_woocommerce_downloadable_product_permissions: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_woocommerce_order_items: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_woocommerce_order_itemmeta: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_woocommerce_tax_rates: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_woocommerce_tax_rate_locations: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_woocommerce_shipping_zones: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_woocommerce_shipping_zone_locations: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
    wp_woocommerce_shipping_zone_methods: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_woocommerce_payment_tokens: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
    wp_woocommerce_payment_tokenmeta: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
    wp_woocommerce_log: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
    wp_actionscheduler_actions: Datos: 0.11MB + Índice: 0.19MB + Motor InnoDB
    wp_actionscheduler_claims: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
    wp_actionscheduler_groups: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
    wp_actionscheduler_logs: Datos: 0.08MB + Índice: 0.06MB + Motor InnoDB
    wp_categorymeta: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_cli_cookie_scan: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_cli_cookie_scan_categories: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
    wp_cli_cookie_scan_cookies: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
    wp_cli_cookie_scan_url: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_cli_scripts: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_commentmeta: Datos: 0.00MB + Índice: 0.01MB + Motor MyISAM
    wp_comments: Datos: 0.01MB + Índice: 0.01MB + Motor MyISAM
    wp_icl_content_status: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_icl_core_status: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_icl_flags: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_icl_languages: Datos: 0.00MB + Índice: 0.01MB + Motor MyISAM
    wp_icl_languages_translations: Datos: 0.10MB + Índice: 0.08MB + Motor MyISAM
    wp_icl_locale_map: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_icl_message_status: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_icl_node: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_icl_reminders: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_icl_strings: Datos: 0.02MB + Índice: 0.02MB + Motor MyISAM
    wp_icl_string_positions: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_icl_string_status: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_icl_string_translations: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_icl_translate: Datos: 0.98MB + Índice: 0.10MB + Motor MyISAM
    wp_icl_translate_job: Datos: 0.01MB + Índice: 0.02MB + Motor MyISAM
    wp_icl_translations: Datos: 0.09MB + Índice: 0.11MB + Motor MyISAM
    wp_icl_translation_status: Datos: 0.33MB + Índice: 0.01MB + Motor MyISAM
    wp_links: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_masterslider_options: Datos: 0.04MB + Índice: 0.00MB + Motor MyISAM
    wp_masterslider_sliders: Datos: 0.02MB + Índice: 0.00MB + Motor MyISAM
    wp_member_catmeta: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_options: Datos: 2.15MB + Índice: 0.31MB + Motor MyISAM
    wp_portfolio_catmeta: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_postmeta: Datos: 4.69MB + Índice: 1.88MB + Motor MyISAM
    wp_posts: Datos: 4.01MB + Índice: 0.25MB + Motor MyISAM
    wp_product_catmeta: Datos: 0.05MB + Índice: 0.02MB + Motor MyISAM
    wp_termmeta: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
    wp_terms: Datos: 0.02MB + Índice: 0.04MB + Motor MyISAM
    wp_term_relationships: Datos: 0.06MB + Índice: 0.15MB + Motor MyISAM
    wp_term_taxonomy: Datos: 0.02MB + Índice: 0.03MB + Motor MyISAM
    wp_usermeta: Datos: 0.08MB + Índice: 0.01MB + Motor MyISAM
    wp_users: Datos: 0.00MB + Índice: 0.01MB + Motor MyISAM
    wp_wcfm_daily_analysis: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
    wp_wcfm_detailed_analysis: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_wcfm_enquiries: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_wcfm_enquiries_meta: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_wcfm_enquiries_response: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_wcfm_enquiries_response_meta: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_wcfm_fbc_chat_rows: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_wcfm_fbc_chat_sessions: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
    wp_wcfm_fbc_chat_visitors: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_wcfm_fbc_offline_messages: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_wcfm_following_followers: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_wcfm_messages: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_wcfm_messages_modifier: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_wcfm_messages_stat: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_wcfm_support: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_wcfm_support_meta: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_wcfm_support_response: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_wcfm_support_response_meta: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_wc_admin_notes: Datos: 0.05MB + Índice: 0.00MB + Motor InnoDB
    wp_wc_admin_note_actions: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
    wp_wc_category_lookup: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_wc_customer_lookup: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
    wp_wc_download_log: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
    wp_wc_order_coupon_lookup: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
    wp_wc_order_product_lookup: Datos: 0.02MB + Índice: 0.06MB + Motor InnoDB
    wp_wc_order_stats: Datos: 0.02MB + Índice: 0.05MB + Motor InnoDB
    wp_wc_order_tax_lookup: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
    wp_wc_product_meta_lookup: Datos: 0.06MB + Índice: 0.09MB + Motor InnoDB
    wp_wc_reserved_stock: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_wc_tax_rate_classes: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
    wp_wc_webhooks: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
    wp_wysija_campaign: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_wysija_campaign_list: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_wysija_custom_field: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_wysija_email: Datos: 0.03MB + Índice: 0.00MB + Motor MyISAM
    wp_wysija_email_user_stat: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_wysija_email_user_url: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_wysija_form: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_wysija_list: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_wysija_queue: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_wysija_url: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_wysija_url_mail: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_wysija_user: Datos: 0.00MB + Índice: 0.01MB + Motor MyISAM
    wp_wysija_user_field: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_wysija_user_history: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_wysija_user_list: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_yith_wcwl: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_yith_wcwl_lists: Datos: 0.00MB + Índice: 0.00MB + Motor MyISAM
    wp_yoast_indexable: Datos: 1.47MB + Índice: 0.36MB + Motor InnoDB
    wp_yoast_indexable_hierarchy: Datos: 0.05MB + Índice: 0.05MB + Motor InnoDB
    wp_yoast_migrations: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
    wp_yoast_primary_term: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
    wp_yoast_seo_links: Datos: 0.11MB + Índice: 0.09MB + Motor InnoDB
    
    ### Post Type Counts ###
    
    attachment: 534
    block: 20
    customize_changeset: 4
    faq: 12
    member: 11
    nav_menu_item: 480
    page: 43
    portfolio: 17
    porto_builder: 40
    post: 13
    product: 298
    product_variation: 34
    revision: 451
    wpcf7_contact_form: 6
    wysijap: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ❌
    					Tu tienda no está usando HTTPS. Aprende más sobre HTTPS y los certificados SSL.
    Hide errors from visitors: ✔
    
    ### Active Plugins (16) ###
    
    All-in-One WP Migration: por ServMask – 7.49
    Autoptimize: por Frank Goossens (futtta) – 2.9.2
    Editor clásico: por Colaboradores de WordPress – 1.6.2
    Contact Form 7: por Takayuki Miyoshi – 5.5.2
    GDPR Cookie Consent: por WebToffee – 2.0.6
    Duplicate Post Page Menu & Custom Post Type: por Inqsys Technology – 1.8.0
    WPBakery Page Builder: por Michael M - WPBakery.com – 6.7.0
    Porto Theme - Functionality: por P-Themes – 2.2.1
    Really Simple CAPTCHA: por Takayuki Miyoshi – 2.1
    WPML Multilingual CMS: por ICanLocalize – 3.1.5
    Under Construction: por WebFactory Ltd – 3.89
    WooCommerce: por Automattic – 5.8.0
    Yoast SEO: por Equipo Yoast – 17.5
    WP Sitemap Page: por Tony Archambeau – 1.9.0
    WPML String Translation: por ICanLocalize – 2.0.5
    WPML Translation Management: por ICanLocalize – 1.9.4
    
    ### Inactive Plugins (1) ###
    
    WCFM - WooCommerce Frontend Manager: por WC Lovers – 6.5.12
    
    ### Settings ###
    
    API Enabled: ✔
    Force SSL: –
    Currency: EUR (€)
    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 ###
    
    Base de la tienda: #6515 - /tienda-prueba/
    Carrito: #5657 - /carro/
    Finalizar compra: ❌ La visibilidad de la página debe ser pública
    Mi cuenta: #5658 - /mi-cuenta/
    Términos y condiciones: #5536 - /politica-de-proteccion-de-datos/
    
    ### Theme ###
    
    Name: Porto
    Version: 6.2.1
    Author URL: https://www.portotheme.com/
    Child Theme: ❌ – Si estás modificando WooCommerce en un tema padre que no has creado personalmente
    te recomendamos utilizar un tema hijo. Ver: Cómo crear un tema hijo
    
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: porto/woocommerce/archive-product.php
    porto/woocommerce/cart/cart-empty.php
    porto/woocommerce/cart/cart-shipping.php
    porto/woocommerce/cart/cart-totals.php
    porto/woocommerce/cart/cart.php
    porto/woocommerce/cart/cross-sells.php
    porto/woocommerce/cart/mini-cart.php
    porto/woocommerce/cart/proceed-to-checkout-button.php
    porto/woocommerce/cart/shipping-calculator.php
    porto/woocommerce/checkout/form-billing.php
    porto/woocommerce/checkout/form-checkout.php
    porto/woocommerce/checkout/form-coupon.php
    porto/woocommerce/checkout/form-login.php
    porto/woocommerce/checkout/form-pay.php
    porto/woocommerce/checkout/form-shipping.php
    porto/woocommerce/checkout/payment-method.php
    porto/woocommerce/checkout/payment.php
    porto/woocommerce/checkout/review-order.php
    porto/woocommerce/checkout/thankyou.php
    porto/woocommerce/content-product-cat.php
    porto/woocommerce/content-product.php
    porto/woocommerce/content-single-product.php
    porto/woocommerce/content-widget-product.php
    porto/woocommerce/global/form-login.php
    porto/woocommerce/global/quantity-input.php
    porto/woocommerce/global/wrapper-start.php
    porto/woocommerce/loop/add-to-cart.php
    porto/woocommerce/loop/loop-end.php
    porto/woocommerce/loop/loop-start.php
    porto/woocommerce/loop/no-products-found.php
    porto/woocommerce/loop/orderby.php
    porto/woocommerce/loop/pagination.php
    porto/woocommerce/loop/rating.php
    porto/woocommerce/loop/sale-flash.php
    porto/woocommerce/myaccount/dashboard.php
    porto/woocommerce/myaccount/downloads.php
    porto/woocommerce/myaccount/form-add-payment-method.php
    porto/woocommerce/myaccount/form-edit-account.php
    porto/woocommerce/myaccount/form-edit-address.php
    porto/woocommerce/myaccount/form-login.php
    porto/woocommerce/myaccount/form-lost-password.php
    porto/woocommerce/myaccount/form-reset-password.php
    porto/woocommerce/myaccount/lost-password-confirmation.php
    porto/woocommerce/myaccount/my-account.php
    porto/woocommerce/myaccount/my-address.php
    porto/woocommerce/myaccount/my-downloads.php
    porto/woocommerce/myaccount/my-orders.php
    porto/woocommerce/myaccount/navigation.php
    porto/woocommerce/myaccount/orders.php
    porto/woocommerce/myaccount/payment-methods.php
    porto/woocommerce/myaccount/view-order.php
    porto/woocommerce/order/form-tracking.php
    porto/woocommerce/order/order-details-customer.php
    porto/woocommerce/order/order-details.php
    porto/woocommerce/order/order-downloads.php
    porto/woocommerce/order/tracking.php
    porto/woocommerce/single-product/add-to-cart/simple.php
    porto/woocommerce/single-product/add-to-cart/variable.php
    porto/woocommerce/single-product/meta.php
    porto/woocommerce/single-product/product-attributes.php
    porto/woocommerce/single-product/product-image.php
    porto/woocommerce/single-product/product-thumbnails.php
    porto/woocommerce/single-product/rating.php
    porto/woocommerce/single-product/related.php
    porto/woocommerce/single-product/review-meta.php
    porto/woocommerce/single-product/review-rating.php
    porto/woocommerce/single-product/review.php
    porto/woocommerce/single-product/sale-flash.php
    porto/woocommerce/single-product/short-description.php
    porto/woocommerce/single-product/tabs/tabs.php
    porto/woocommerce/single-product/title.php
    porto/woocommerce/single-product/up-sells.php
    porto/woocommerce/single-product-reviews.php
    
    ### Action Scheduler ###
    
    Completo: 547
    Oldest: 2021-10-08 11:33:10 +0000
    Newest: 2021-11-04 10:06:10 +0000
    
    ### Status report information ###
    
    Generated at: 2021-11-04 10:40:23 +00:00
    

    Anyway, I have to edit the CSV again to add the property of product_url. About the product_url, I suppose I have to put the categories I wanna show on it, haven’t I? Like

    https://www.example.com/shop/category-parent/category-child/test-product-123/

    ps. Non related but if I have other problems that doesn’t have anything to do with the import of the products, should I open other topic or is it ok to keep asking in here?

    • This reply was modified 1 month ago by zurdac. Reason: A typo
    Plugin Support Ahmed M. a11n

    (@nagdy)

    Hi @zurdac,

    Thanks for providing this info and for providing the video, it helped a lot identifying the issue you’re having with the product URLs.

    Can you please try the following:

    – Go to Settings > Permalinks and hit the save button.
    – Check the product URLs and see if the issue is fixed.

    If it is not fixed, can you please share a screenshot with me of the Permalinks page (under Settings > Permalinks)

    Regarding the product_url part, you don’t need to add the full slug that includes the categories part. Actually, this field is for external products and the external product is a useful way to add a product on the site that customers will purchase on another site.

    So you can skip this for now if you’re not linking to external products.

    Regarding the other questions, it is always preferred to open a new thread for each issue to not clutter the thread and allow other people to benefit from searching for answers when they have similar issues.

    Looking forward to hearing back from you.

    Thread Starter zurdac

    (@zurdac)

    If it is not fixed, can you please share a screenshot with me of the Permalinks page (under Settings > Permalinks)

    Not only it doesn’t change anything, when I choose an option and update it, it returns to the “customized permalink”. Not sure if this has anything to do with the issue I have on the shop, so I filmed another tiny video for it. There’s also this section (I’ve tried to look for an english translation, but I haven’t found one of this specific section, so it’s in spanish) that I’ve never touched. But the sentence I’ve highlighted maybe has something to do with my issue.

    Actually, this field is for external products

    Aaah, then I had understood well the use of that property at first. Then we don’t have any option to make the permalink customized, do we? My products have this URL by default (not talking about the categories here, we already know that my categories on the URL are a mess, just the import-placeholder):

    http://www.elsbanys.es/tienda-prueba/sin%20categoría/import-placeholder-for-4883/

    So, after uploading my CSV, I have to go one by one changing the slug. So my question was if I have any option to make that in a faster and easier way.

    Thank you so so much for your attention with my issues and for your kind words every time.

    Plugin Support fevered – a11n

    (@fevered)

    Thank you for all this!

    We mentioned earlier in the thread trying a conflict test, is that something you were ever able to try for either of these issues? I would recommend that as a next step if you haven’t already tried that.

    Thread Starter zurdac

    (@zurdac)

    Hello!

    Funnily enough, I returned to that first suggestion, and I’m trying to read the documentation, but right now https://woocommerce.com/es-es/document/how-to-test-for-conflicts has an error 404, so I can’t see how I should do a conflict test.

    I’m gonna try to find any blog or video explaining how to do it. But because I’m not a developer (just a designer with pretty bad luck), any other suggestion or a tiny explanation for dummies about what should I do to run a conflict test, it’s more than welcome.

    Plugin Support maykato

    (@maykato)

    Hi @zurdac

    Here is the correct link to the conflict test page: https://woocommerce.com/document/how-to-test-for-conflicts/

    Basically, you’ll need to isolate the issue by deactivating all plugins except the WooCommerce and switching your theme to a default theme like Storefront. If your CSV updates products properly on that environment, then re-enable plugins one-by-one until you find the one that’s causing the conflict.

    I hope it helps.

    Thread Starter zurdac

    (@zurdac)

    I’ve found it!

    As I commented before, this website is pretty old and needed a heavy actualization when I started to work with it. It seems like the plugins that were used to make the website multilingual (WPML multilingual CMS, WPML string translation and WPML translation management), didn’t update themselves like the other plugins. Actually, they look as if they’re already updated. Not sure if it’s because right now they have another name or whatever, but yeah, here is the problem.

    I’ve deactivated them and the URLs finally look normal with its categories and all of that. Anyway, if I go to the debug log, it still shows some issues about one of the plugins that supposedly are deactivated. Now I just have to find a properly updated plugin to make the site multilingual.

    It looks like this has been resolved, but I will left this as unresolved until I’ve checked with the new plugin (and with the rest of plugins), if there’s no inconvenient with that.

    Thank you so much to everyone who has tried to help me, it has been a pleasure.

    Plugin Support AW a11n

    (@slash1andy)

    Automattic Happiness Engineer

    Hey again!

    Glad to hear that this is resolved now, at least you know what’s causing the issues now.

    We usually close out threads in a few days if we don’t hear back from you, so it gives you a few days to figure out if you need to come back with more questions, or if you are good to go.

Viewing 15 replies - 1 through 15 (of 16 total)
  • You must be logged in to reply to this topic.