• Resolved kiona75

    (@kiona75)


    I’m trying to do an import for the products after a price edit.

    I first export from products.
    Choice is a simple product.
    I open in Numbers (table data with separator value is comma, in advanced settings the text encoding is Unicode (UTF-8))
    Edit the price. Export to CSV file.

    In WP I go to products and import. That’s where I look for my file. What always remains the same is that I check that I want to update products.
    In advanced settings I have done several options here.

    I tried semicolon on separator.
    Using previous column layout preferences? I have tried both: off and checked.

    I can’t get past column 1 the ID, the other columns are not recognized. What am I doing wrong?

    Numbers version 12.1
    WP version 5.9.5
    Woocommerce version 7.0.0

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Hi @kiona75

    Thanks for reaching out!

    I open in Numbers (table data with separator value is comma, in advanced settings the text encoding is Unicode (UTF-8))

    I didn’t quite get this process on my test site. Could you please provide further details on what you are referring to here?

    If a screenshot would be helpful, I’d recommend using https://snipboard.io or http://skitch.com/. You can share the direct link to the image as a response to this topic.

    I can’t get past column 1 the ID, the other columns are not recognized. What am I doing wrong?

    Can you please share with us a copy of the CSV file you are using with sample data in it so that we could check this further?

    Furthermore, I’d like to understand your site properly, can you please share your System Status Report, that will help us further troubleshoot.

    You can find it via WooCommerce > Status. Select Get system report and then Copy for support. Once you’ve done that, you can paste it into your reply here.

    Thread Starter kiona75

    (@kiona75)

    Hi Xue28,

    I add a screenshot when I open CSV in Numbers:
    Numbers open CSV file export woocommerce

    My CSV file that is exported from Woocommerce:
    original CSV file

    My CSV file that is edited for import.
    edited CSV file

    Below you can find the systemreport of woocommerce:

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://servicebox.be/sonal
    Site address (URL): https://servicebox.be/sonal
    WC Version: 7.0.0
    REST API Version: ✔ 7.0.0
    WC Blocks Version: ✔ 8.5.1
    Action Scheduler Version: ✔ 3.4.0
    Log Directory Writable: ✔
    WP Version: ❌ 5.9.5 - Er is een nieuwere versie van WordPress beschikbaar (6.0.3)
    WP Multisite: –
    WP Memory Limit: 512 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: nl_NL
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: LiteSpeed
    PHP Version: 7.4.32
    PHP Post Max Size: 512 MB
    PHP Time Limit: 300
    PHP Max Input Vars: 1000
    cURL Version: 7.71.0
    OpenSSL/1.1.1p
    
    SUHOSIN Installed: –
    MySQL Version: 10.5.17-MariaDB-cll-lve
    Max Upload Size: 256 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 5.5.2
    WC Database Prefix: wpsa_
    Totale database grootte: 43.06MB
    Database gegevens grootte: 28.18MB
    Database index grootte: 14.88MB
    wpsa_woocommerce_sessions: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
    wpsa_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsa_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpsa_woocommerce_order_items: Data: 0.08MB + Index: 0.02MB + Engine InnoDB
    wpsa_woocommerce_order_itemmeta: Data: 1.52MB + Index: 0.45MB + Engine InnoDB
    wpsa_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpsa_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpsa_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpsa_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsa_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_actionscheduler_actions: Data: 0.50MB + Index: 0.81MB + Engine InnoDB
    wpsa_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_actionscheduler_logs: Data: 0.27MB + Index: 0.23MB + Engine InnoDB
    wpsa_aelia_dismissed_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_aelia_exchange_rates_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_ahm_assets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_ahm_asset_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_ahm_download_stats: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wpsa_ahm_emails: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_ahm_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_ahm_social_conns: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_ahm_user_download_counts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_c2q: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsa_comments: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
    wpsa_ddownload_statistics: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wpsa_dopbsp_api_keys: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_dopbsp_calendars: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpsa_dopbsp_coupons: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_dopbsp_days: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wpsa_dopbsp_days_available: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsa_dopbsp_days_unavailable: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsa_dopbsp_discounts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_dopbsp_discounts_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_dopbsp_discounts_items_rules: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_dopbsp_emails: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_dopbsp_emails_translation: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsa_dopbsp_extras: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_dopbsp_extras_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_dopbsp_extras_groups_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_dopbsp_fees: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_dopbsp_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_dopbsp_forms_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_dopbsp_forms_select_options: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_dopbsp_languages: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsa_dopbsp_locations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_dopbsp_models: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_dopbsp_reservations: Data: 0.02MB + Index: 0.13MB + Engine InnoDB
    wpsa_dopbsp_rules: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_dopbsp_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_dopbsp_settings_calendar: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsa_dopbsp_settings_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsa_dopbsp_settings_payment: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsa_dopbsp_translation_en: Data: 0.27MB + Index: 0.13MB + Engine InnoDB
    wpsa_dopbsp_woocommerce: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wpsa_download_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_duplicator_packages: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_ea_error_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_fb3d_pages: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpsa_filemeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpsa_gf_addon_feed: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_gf_entry: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wpsa_gf_entry_meta: Data: 0.13MB + Index: 0.09MB + Engine InnoDB
    wpsa_gf_entry_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsa_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_gf_form_meta: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
    wpsa_gf_form_revisions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsa_gf_form_view: Data: 0.27MB + Index: 0.23MB + Engine InnoDB
    wpsa_gf_rest_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsa_icl_content_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_icl_core_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_icl_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_icl_languages: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsa_icl_languages_translations: Data: 0.20MB + Index: 0.14MB + Engine InnoDB
    wpsa_icl_locale_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_icl_message_status: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsa_icl_node: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_icl_reminders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_icl_strings: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wpsa_icl_string_positions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_icl_string_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_icl_string_translations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_icl_translate: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_icl_translate_job: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_icl_translations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpsa_icl_translation_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_options: Data: 3.48MB + Index: 0.14MB + Engine InnoDB
    wpsa_postmeta: Data: 4.52MB + Index: 3.03MB + Engine InnoDB
    wpsa_posts: Data: 5.52MB + Index: 0.38MB + Engine InnoDB
    wpsa_ps_exclude: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_ps_postmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsa_ps_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_ps_product_sku: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_pts_tables: Data: 0.36MB + Index: 0.00MB + Engine InnoDB
    wpsa_redirection_404: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpsa_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsa_redirection_items: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wpsa_redirection_logs: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wpsa_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
    wpsa_revslider_css_bkp: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wpsa_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_revslider_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_revslider_sliders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_revslider_sliders_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_revslider_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_revslider_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_rg_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_rg_form_meta: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
    wpsa_rg_form_view: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
    wpsa_rg_incomplete_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_rg_lead: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsa_rg_lead_detail: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpsa_rg_lead_detail_long: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_rg_lead_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpsa_rg_lead_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsa_sdm_downloads: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsa_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsa_term_relationships: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
    wpsa_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsa_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsa_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_usermeta: Data: 5.52MB + Index: 5.03MB + Engine InnoDB
    wpsa_users: Data: 1.52MB + Index: 0.53MB + Engine InnoDB
    wpsa_wc_admin_notes: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    wpsa_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    wpsa_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsa_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsa_wc_order_bundle_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wpsa_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsa_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpsa_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpsa_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsa_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsa_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_wc_product_meta_lookup: Data: 0.05MB + Index: 0.09MB + Engine InnoDB
    wpsa_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_woocommerce_bundled_itemmeta: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
    wpsa_woocommerce_bundled_items: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsa_wpdevart_calendars: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_wpdevart_dates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_wpdevart_extras: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_wpdevart_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_wpdevart_payments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_wpdevart_reservations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_wpdevart_themes: Data: 0.03MB + Index: 0.00MB + Engine InnoDB
    wpsa_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpsa_yoast_indexable: Data: 0.06MB + Index: 0.09MB + Engine InnoDB
    wpsa_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpsa_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpsa_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpsa_yoast_seo_links: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
    wpsa_yoast_seo_meta: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wpsa_yumpu_documents: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    al_product: 1
    attachment: 112
    br_labels: 1
    custom_css: 1
    customize_changeset: 34
    faqs: 7
    nav_menu_item: 25
    page: 30
    post: 2
    postman_sent_mail: 250
    product: 109
    product_variation: 38
    quote: 3
    revision: 519
    shop_order: 162
    spb-section: 1
    tm_global_cp: 1
    tm_product_cp: 1
    yith-wcbm-badge: 2
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (30) ###
    
    All-in-One WP Migration: door ServMask – 7.66
    Gravity Forms: door Gravity Forms – 2.6.7
    WooCommerce (nl): door Pronamic – 1.1.7
    Template Library and Redux Framework: door Extendify – 4.3.19
    Advanced Code Editor: door BaInternet – 2.2.7
    Black Studio TinyMCE Widget: door Black Studio – 2.7.2
    Breadcrumb NavXT: door John Havlik – 7.1.0
    Cookie Notice & Compliance for GDPR / CCPA: door Hu-manity.co – 2.4.1
    createIT Catalog Plugin: door createIT – 1.6
    Custom Related Products for WooCommerce: door Scott Nelle – 1.3
    Disable Comments: door WPDeveloper – 2.4.2
    Easy Booking: Duration Discounts: door @_Ashanna – 1.9.1
    MainWP Child: door MainWP – 4.2.6
    Max Mega Menu: door megamenu.com – 3.0
    Meta Box: door MetaBox.io – 5.6.7
    Password Strength for WooCommerce: door Aspen Grove Studios – 1.0.2
    Post SMTP: door Post SMTP – 2.1.10
    Shortcodes Ultimate: door Vladimir Anokhin – 5.12.2
    Swift Framework: door Swift Ideas – 2.7.29
    UPS (BASIC) WooCommerce Shipping: door PluginHive – 1.2.14
    Aelia Foundation Classes for WooCommerce: door Aelia – 2.3.2.221012
    WooCommerce Blocks: door Automattic – 7.8.0
    WooCommerce Easy Booking: door @_Ashanna – 3.1.0
    WooCommerce EU BTW Assistent: door Aelia – 2.0.35.221012
    WooCommerce Product Bundles: door WooCommerce – 6.17.2
    WooCommerce Product Fees: door Caleb Burks – 1.3.0
    WooCommerce TM Extra Product Options: door themeComplete – 4.7.1
    WooCommerce: door Automattic – 7.0.0
    Custom Product Tabs for WooCommerce: door YIKES
    Inc. – 1.8.1
    
    YITH WooCommerce Badge Management: door YITH – 2.10.0
    
    ### Inactive Plugins (18) ###
    
    Akismet Anti-Spam: door Automattic – 4.2.4
    Download Manager: door W3 Eden
    Inc. – 3.2.39
    
    Duplicator: door Snap Creek – 1.4.4
    Easy Booking: Disable Dates: door @_Ashanna – 1.5.7
    Hello Dolly: door Matt Mullenweg – 1.7.2
    Limit Login Attempts Reloaded: door Limit Login Attempts Reloaded – 2.23.2
    Migrate Guru: door Migrate Guru – 4.72
    Postman SMTP: door Jason Hendriks – 1.7.2
    Redirection: door John Godley – 5.2.3
    SiteGround Migrator: door SiteGround – 1.0.29
    Slider Revolution: door ThemePunch – 5.4.5.1
    UpdraftPlus - Backup/Restore: door UpdraftPlus.Com
    DavidAnderson – 1.22.11
    
    WooCommerce Admin: door WooCommerce – 3.3.2
    WooCommerce Simply Order Export: door Ankit Gade – 3.0.13
    WPDM - TinyMce Button: door Shaon – 2.7.2
    Wp Maximum Upload File Size: door CodePopular – 1.0.8
    WP Super Cache: door Automattic – 1.7.7
    Yoast SEO: door Team Yoast – 18.3
    
    ### Dropin Plugins (1) ###
    
    maintenance.php: maintenance.php
    
    ### Settings ###
    
    API Enabled: ✔
    Force SSL: –
    Currency: EUR (€)
    Currency Position: left
    Thousand Separator: 
    Decimal Separator: ,
    Number of Decimals: 2
    Taxonomies: Product Types: bundle (bundle)
    external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)
    wcpb (wcpb)
    
    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: –
    
    ### WC Pages ###
    
    Winkelbasis: #7 - /webshop/
    Winkelwagen: #8 - /winkelmand/
    Afrekenen: #9 - /afrekenen/
    Mijn account: #10 - /mijn-account/
    Algemene voorwaarden: #16 - /algemene-voorwaarden/
    
    ### Theme ###
    
    Name: Uplift Child Theme
    Version: 1.0
    Author URL: http://www.swiftideas.com
    Child Theme: ✔
    Parent Theme Name: Uplift
    Parent Theme Version: 1.4.26
    Parent Theme Author URL: http://www.swiftideas.com
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: uplift/woocommerce/archive-product.php
    /home/service/public_html/sonal/wp-content/plugins/woocommerce-tm-extra-product-options/templates/cart/cart-item-data.php
    uplift/woocommerce/cart/cart-totals.php
    uplift/woocommerce/cart/cart.php
    uplift/woocommerce/checkout/form-checkout.php
    uplift/woocommerce/checkout/thankyou.php
    uplift/woocommerce/content-product.php
    uplift/woocommerce/content-single-product.php
    uplift/woocommerce/global/quantity-input.php
    uplift/woocommerce/loop/add-to-cart.php
    uplift/woocommerce/loop/loop-end.php
    uplift/woocommerce/loop/loop-start.php
    uplift/woocommerce/loop/orderby.php
    uplift/woocommerce/loop/pagination.php
    uplift/woocommerce/loop/result-count.php
    uplift/woocommerce/myaccount/form-login.php versie 4.1.0 is verouderd. De hoofdversie is 6.0.0
    uplift/woocommerce/myaccount/my-address.php
    uplift/woocommerce/myaccount/my-orders.php
    uplift/woocommerce/single-product/add-to-cart/external.php
    uplift/woocommerce/single-product/add-to-cart/grouped.php
    uplift/woocommerce/single-product/add-to-cart/simple.php
    uplift/woocommerce/single-product/add-to-cart/variable.php versie 3.5.5 is verouderd. De hoofdversie is 6.1.0
    uplift/woocommerce/single-product/add-to-cart/variation-add-to-cart-button.php
    uplift/woocommerce/single-product/product-image.php
    uplift/woocommerce/single-product/product-thumbnails.php
    uplift/woocommerce/single-product/related.php
    uplift/woocommerce/single-product/review.php
    uplift/woocommerce/single-product/tabs/description.php
    uplift/woocommerce/single-product/tabs/tabs.php
    uplift/woocommerce/single-product/up-sells.php
    uplift/woocommerce/single-product-reviews.php
    uplift/woocommerce/single-product.php
    uplift/woocommerce/content-product_cat.php
    
    Outdated Templates: ❌
    					
    					
    						Leer hoe te updaten
    
    ### Product Bundles ###
    
    Database Version: 6.17.2
    Loopback Test: ✔
    Template Overrides: –
    
    ### Admin ###
    
    Enabled Features: activity-panels
    analytics
    coupons
    customer-effort-score-tracks
    experimental-products-task
    experimental-import-products-task
    experimental-fashion-sample-products
    experimental-product-tour
    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
    settings
    
    Daily Cron: ✔ Next scheduled: 2022-10-25 08:21:50 +01:00
    Options: ✔
    Notes: 105
    Onboarding: completed
    
    ### Action Scheduler ###
    
    Afgerond: 1.238
    Oldest: 2022-09-24 07:51:34 +0000
    Newest: 2022-10-25 07:27:37 +0000
    
    In afwachting: 5
    Oldest: 2022-10-25 08:25:08 +0000
    Newest: 2022-10-28 15:20:18 +0000
    
    ### Status report information ###
    
    Generated at: 2022-10-25 08:35:30 +01:00
    

    Hello,

    If I understand correctly, the CSV file is not recognized.

    Can you please try again, but this time use another spreadsheet editor, for example, Google sheets, or LibreOffice, the fact is, that MS Excel tends to change some numbers into scientific notation, that does not happen all the times, but that could happen.

    Please note, your file will need to be created according to this schema:
    https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Import-Schema

    Let us know if there are any questions.

    Thread Starter kiona75

    (@kiona75)

    Thanks!

    It was Numbers that wasn’t handling the export well. With LibreOffice the import is working.

    Kind regards.
    Kiona

    Saif

    (@babylon1999)

    Hello @kiona75,

    It was Numbers that wasn’t handling the export well. With LibreOffice the import is working.

    Glad to hear everything is working now. 😃

    I will go ahead and mark this thread as solved. If you have a few minutes, we’d love it if you could leave us a review: https://wordpress.org/support/plugin/woocommerce/reviews/

    Cheers!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Export/import’ is closed to new replies.