dave88nl
Forum Replies Created
-
Forum: Plugins
In reply to: [WooCommerce] Woocommerce csv importer won’t update categoriesSo I found the solution. I don’t know why but this is what I found.
In the csv I got when exported I have two columns:
Categorieën (dutch for categories) and a seconnd column named CategoriesThe first Categorieën has the default value (no categorie) and the second one is empty. I never found it just now when I looked at all the columns.
So I filled in a value in the second Categorie column and imported the csv. And now it works and the product has the new value.
Thanks all for helping out. If you have more questions, just let me know.
Forum: Plugins
In reply to: [WooCommerce] Woocommerce csv importer won’t update categoriesI saw in onther post that tags and categories shouldn’t be the same in each (it is an old post) but is this true and could be the issue?
https://wordpress.com/forums/topic/i-cant-update-my-categories/Forum: Plugins
In reply to: [WooCommerce] Woocommerce csv importer won’t update categoriesHello,
Thanks for your reply. It is for updating an excisting item.
To give a complete image, all of my items (9900+ items) have empty or ‘geen categorie’ in the categorie column. I don’t know when it happened. So I need to change it back to what it was (in previous exported product lists I have them correctly).
The csv I am using I shared it on my drive: https://docs.google.com/spreadsheets/d/1RJgX1aRXiDdX6d4iRDd1wQSvbjFVTas28Y-CAGzjU0Q/edit?usp=sharing
Forum: Plugins
In reply to: [WooCommerce] Woocommerce csv importer won’t update categoriesSo I did the following just now:
- I did an export with all products with the WooCommerce’s built-in export tool (like I always do)
- I use Libeoffice Calc or Google Sheets (in this case sheets)
- I removed all products except the one I use for updating the categorie (ID: 27118)
- I change the Categorieen value into ‘Funko’ and download the document as a .csv, also change the description to know for sure the product has been updated
- In Woocommerce I go the Products > Import
- I upload the .csv file and check the ‘update excisting products’ option
- On the following page I double check if the categories value is showing in the example
https://drive.google.com/file/d/1cnNWF-Tq8to_FV1gC2_rDVVBLj-2RNQA/view?usp=sharing - Then I click on import and wait till its completed
- On the page I refresh and I see the description is changed, but the categorie is still ‘geen categorie’
So no luck. Has it something to do with the product is published? The url is now https://www.pickapop.nl/shop/geen-categorie/roronoa-zoro-nothing-happened-1496-one-piece/
So its linked to the categorie. Is that something why it’s locked?
Forum: Plugins
In reply to: [WooCommerce] Woocommerce csv importer won’t update categoriesHello,
Tried the suggestions you proposed, but didn’t work unfortnuatly. I tried to keep it simple with just a main categorie and also checked on spaces.
Here is my screen capture of the process. Ofcourse it was taking a long time when uploading, sorry about that: https://drive.google.com/file/d/1YgQCQsFwijD6cEvSfuA-27tS597aQbxs/view?usp=sharing
Hope you can find something I do wrong.
Kind regards
Forum: Plugins
In reply to: [WooCommerce] Woocommerce csv importer won’t update categoriesHello,
The categories are already there.
kind regards,
Dave
Forum: Plugins
In reply to: [WooCommerce] Shipping calculation not working for NetherlandsThank you for your reply.
I added the Netherlands as a options to send to (see image below)
https://www.screencast.com/t/wSXuZXYo0nTBelow you will find my status report.
The funny thing is that the costs are there when the order has been done in my orders overview:
https://www.screencast.com/t/rOrcnowfhLooking for your reply.
Kind regards,
Dave
Status message:
` ### WordPress Environment ### WordPress address (URL): https://www.pickapop.nl Site address (URL): https://www.pickapop.nl WC Version: 7.5.1 REST API Version: ✔ 7.5.1 WC Blocks Version: ✔ 9.6.6 Action Scheduler Version: ✔ 3.5.4 Log Directory Writable: ✔ WP Version: 6.2 WP Multisite: – WP Memory Limit: 1 GB WP Debug Mode: – WP Cron: ✔ Language: nl_NL External object cache: – ### Server Environment ### Server Info: Apache PHP Version: 8.1.15 PHP Post Max Size: 1 GB PHP Time Limit: 60 PHP Max Input Vars: 3000 cURL Version: 7.64.0 OpenSSL/1.1.1n SUHOSIN Installed: – MySQL Version: 10.4.26-MariaDB-log Max Upload Size: 1 GB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ ### Database ### WC Database Version: 7.5.1 WC Database Prefix: wp_ Totale database grootte: 428.19MB Database gegevens grootte: 396.80MB Database index grootte: 31.39MB wp_woocommerce_sessions: Data: 1.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.14MB + Index: 0.06MB + Engine InnoDB wp_woocommerce_order_itemmeta: Data: 1.52MB + Index: 0.66MB + 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: 1.02MB + Index: 0.63MB + 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: 1.03MB + Index: 0.72MB + Engine InnoDB wp_barcode_v3_dimension: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_barcode_v3_fields_matching: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_barcode_v3_label_sheets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_barcode_v3_paper_formats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_barcode_v3_profiles: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_barcode_v3_templates: Data: 0.05MB + Index: 0.00MB + Engine InnoDB wp_barcode_v3_template_to_user: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_barcode_v3_user_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_berocket_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_bwg_album: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_bwg_album_gallery: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_bwg_file_paths: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_bwg_gallery: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_bwg_image: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_bwg_image_comment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_bwg_image_rate: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_bwg_image_tag: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_bwg_shortcode: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_bwg_theme: Data: 0.08MB + Index: 0.00MB + Engine InnoDB wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_comments: Data: 1.52MB + Index: 0.59MB + Engine InnoDB wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mollie_pending_payment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_newsletter: Data: 0.17MB + Index: 0.06MB + Engine InnoDB wp_newsletter_emails: Data: 4.52MB + Index: 0.00MB + Engine InnoDB wp_newsletter_sent: Data: 0.27MB + Index: 0.22MB + Engine InnoDB wp_newsletter_stats: Data: 0.09MB + Index: 0.06MB + Engine InnoDB wp_newsletter_user_logs: Data: 0.06MB + Index: 0.00MB + Engine InnoDB wp_nextend2_image_storage: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nextend2_section_storage: Data: 0.09MB + Index: 0.06MB + Engine InnoDB wp_nextend2_smartslider3_generators: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nextend2_smartslider3_sliders: Data: 0.08MB + Index: 0.05MB + Engine InnoDB wp_nextend2_smartslider3_sliders_xref: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nextend2_smartslider3_slides: Data: 0.16MB + Index: 0.11MB + Engine InnoDB wp_options: Data: 9.44MB + Index: 0.25MB + Engine InnoDB wp_pmxe_exports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB + Engine InnoDB wp_pmxe_posts: Data: 0.14MB + Index: 0.00MB + Engine InnoDB wp_pmxe_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_postmeta: Data: 17.55MB + Index: 8.03MB + Engine InnoDB wp_posts: Data: 6.52MB + Index: 0.81MB + Engine InnoDB wp_snippets: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_termmeta: Data: 0.09MB + Index: 0.13MB + Engine InnoDB wp_terms: Data: 0.06MB + Index: 0.03MB + Engine InnoDB wp_term_relationships: Data: 1.50MB + Index: 0.45MB + Engine InnoDB wp_term_taxonomy: Data: 0.06MB + Index: 0.06MB + Engine InnoDB wp_trp_dictionary_nl_nl_en_us: Data: 2.52MB + Index: 1.98MB + Engine InnoDB wp_trp_gettext_en_us: Data: 0.41MB + Index: 0.39MB + Engine InnoDB wp_trp_gettext_nl_nl: Data: 1.52MB + Index: 0.44MB + Engine InnoDB wp_trp_original_meta: Data: 0.39MB + Index: 0.47MB + Engine InnoDB wp_trp_original_strings: Data: 2.52MB + Index: 1.52MB + Engine InnoDB wp_ucp_leads: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_ucp_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_ucp_stats: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_ucp_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_ulike: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_ulike_activities: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_ulike_comments: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_ulike_forums: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_ulike_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_usermeta: Data: 1.52MB + Index: 0.36MB + Engine InnoDB wp_users: Data: 0.05MB + Index: 0.05MB + Engine InnoDB wp_wc_admin_notes: Data: 0.08MB + Index: 0.00MB + Engine InnoDB wp_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB wp_wc_cancel_orders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_customer_lookup: Data: 0.06MB + 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.13MB + Index: 0.16MB + Engine InnoDB wp_wc_order_stats: Data: 0.09MB + Index: 0.05MB + Engine InnoDB wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_product_attributes_lookup: Data: 0.13MB + Index: 0.13MB + Engine InnoDB wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_product_meta_lookup: Data: 0.23MB + Index: 0.45MB + Engine InnoDB wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + 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_wdi_feeds: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wdi_themes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wml_entries: Data: 332.52MB + Index: 0.00MB + Engine InnoDB wp_wpfb_gettwitter_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpf_filters: Data: 0.03MB + Index: 0.00MB + Engine InnoDB wp_wpf_meta_data: Data: 0.48MB + Index: 0.91MB + Engine InnoDB wp_wpf_meta_keys: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wpf_meta_values: Data: 0.02MB + Index: 8.19MB + Engine InnoDB wp_wpf_meta_values_bk: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wpf_modules: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wpf_modules_type: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpf_usage_stat: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wpmailsmtp_debug_events: Data: 0.36MB + Index: 0.00MB + Engine InnoDB wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpml_mails: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wprss_logs: Data: 0.05MB + Index: 0.00MB + Engine InnoDB wp_wt_iew_action_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wt_iew_cron: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wt_iew_ftp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_yoast_indexable: Data: 4.33MB + Index: 1.75MB + Engine InnoDB wp_yoast_indexable_hierarchy: Data: 0.14MB + Index: 0.22MB + Engine InnoDB wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_yoast_seo_links: Data: 0.06MB + Index: 0.03MB + Engine InnoDB ### Post Type Counts ### attachment: 4912 br_filters_group: 1 br_product_filter: 2 custom_css: 3 customize_changeset: 5 elementor_library: 6 feedzy_imports: 1 jb_store_css: 5 language_switcher: 4 mc4wp-form: 1 nav_menu_item: 9 oembed_cache: 21 page: 35 post: 91 product: 1910 qr: 1 qrcode: 2 revision: 475 shop_coupon: 15 shop_order: 702 shop_order_refund: 37 wp_global_styles: 1 wpcf7_contact_form: 6 wpcf7r_action: 2 wprss_feed: 1 wprss_feed_item: 15 wprss_feed_template: 1 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (41) ### Code Snippets: door Code Snippets Pro – 3.3.0 Contact Form 7: door Takayuki Miyoshi – 5.7.5.1 Cost of Goods for WooCommerce Pro: door WPFactory – 2.5.0 Cost of Goods for WooCommerce: door WPFactory – 2.9.3 EU Cookie Law: door Alex Moss Marco Milesi – 3.1.6 Font Awesome: door Font Awesome – 4.3.2 GTranslate: door Translate AI Multilingual Solutions – 3.0.2 Head & Footer Code: door Aleksandar Urošević – 1.3.1 Jetpack Boost: door Automattic - Jetpack Site Speed team – 1.7.0 Jetpack: door Automattic – 11.9.1 Collapse-O-Matic: door twinpictures baden03 – 1.8.3 Kaya QR Code Generator: door Kaya Studio – 1.5.2 Menu Icons: door ThemeIsle – 0.13.5 Mollie Payments for WooCommerce: door Mollie – 7.3.5 Newsletter - Addons Manager: door The Newsletter Team – 1.2.0 Newsletter - Import: door The Newsletter Team – 1.3.7 Newsletter: door Stefano Lissa & Het Newsletter Team – 7.6.9 Page scroll to id: door malihu – 1.7.7 Barcode Label Printing for WooCommerce and others plugins - (basic): door UkrSolution – 3.4.5 Really Simple SSL: door Really Simple Plugins – 6.2.3 Simple Banner: door Ryan Petersen – 2.13.3 Smart Slider 3: door Nextend – 3.5.1.14 Trustpilot-reviews: door Trustpilot – 2.5.914 UnderConstructionPage PRO: door Web factory Ltd – 5.68 WC Cancel Order: door WpExperts Hub – 3.2 WC Hide Shipping Methods: door Rynaldo Stoltz – 1.5 Product Filter by WBW: door WBW – 2.3.2 WooCommerce Checkout Manager: door QuadLayers – 7.1.0 Customizer for WooCommerce: door SkyVerge – 2.7.7 Extra Product Sorting Options for WooCommerce: door SkyVerge – 2.9.1 WP Menu Cart: door WP Overnight – 2.14.0 Invoices for WooCommerce: door Bas Elbers – 3.1.9 WooCommerce Remove All Products: door Gabriel Reguly Erik Golinelli – 6.4 WooCommerce Shipping & Tax: door WooCommerce – 2.2.4 WooCommerce: door Automattic – 7.5.1 Yoast SEO: door Team Yoast – 20.4 WP Mail Log: door WPVibes – 1.1 WP Mail SMTP: door WPForms – 3.7.0 ReCaptcha v2 voor Contact Form 7: door IQComputing – 1.4.3 Doorverwijzing voor Contact Form 7: door Qube One – 2.8.0 WPForms Lite: door WPForms – 1.8.1.1 ### Inactive Plugins (2) ### Confetti Animation: door [email protected] – 1.0 Feedzy RSS Feeds Lite: door Themeisle – 3.7.4 ### 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: – Enforce Approved Product Download Directories: – Order datastore: WC_Order_Data_Store_CPT ### WC Pages ### Winkelbasis: #109 - /shop-exclusieve-funko-pops/ Winkelwagen: #110 - /cart/ Afrekenen: #111 - /checkout/ Mijn account: #112 - /my-account/ Algemene voorwaarden: #428 - /algemene-voorwaarden-shop/ ### Theme ### Name: Rife free Child Version: 1.0.0 Author URL: http://example.com Child Theme: ✔ Parent Theme Name: Rife Free Parent Theme Version: 2.4.16.1 Parent Theme Author URL: https://apollo13themes.com/ WooCommerce Support: ✔ ### Templates ### Overrides: rife-free/woocommerce/archive-product.php rife-free-child/woocommerce/emails/customer-completed-order.php rife-free-child/woocommerce/emails/customer-on-hold-order.php versie 3.7.0 is verouderd. De hoofdversie is 7.3.0 rife-free/woocommerce/loop/loop-start.php Outdated Templates: ❌ Leer hoe te updaten ### Admin ### Enabled Features: activity-panels analytics coupons customer-effort-score-tracks import-products-task experimental-fashion-sample-products shipping-smart-defaults shipping-setting-tour homescreen marketing multichannel-marketing mobile-app-banner navigation onboarding onboarding-tasks remote-inbox-notifications remote-free-extensions payment-gateway-suggestions shipping-label-banner subscriptions store-alerts transient-notices woo-mobile-welcome wc-pay-promotion wc-pay-welcome-page Disabled Features: minified-js new-product-management-experience product-variation-management settings Daily Cron: ✔ Next scheduled: 2023-04-06 22:26:12 +02:00 Options: ✔ Notes: 122 Onboarding: completed ### Action Scheduler ### Afgerond: 1.404 Oldest: 2023-03-07 19:11:04 +0100 Newest: 2023-04-06 21:10:25 +0200 Mislukt: 22 Oldest: 2022-02-08 06:05:57 +0100 Newest: 2023-04-06 18:31:05 +0200 In afwachting: 7 Oldest: 2023-04-07 06:50:18 +0200 Newest: 2023-04-10 15:28:34 +0200 ### Status report information ### Generated at: 2023-04-06 21:18:33 +02:00 `Forum: Plugins
In reply to: [WooCommerce] Woocommerce product export result in 429So in the meantime I contacted the guy who host my server. They changed the .htaccess file with the following values:
php_value memory_limit 1024M php_value upload_max_filesize 1024M php_value post_max_size 1024M php_value max_execution_time 60 php_value max_input_time 120 php_value max_input_vars 3000That worked for me.
Forum: Fixing WordPress
In reply to: Woocommerce product export result in 429I will do. Thank you for your reply