Unable to upload a products csv file

  • Resolved LandyVlad

    (@landyvlad)


    1 year, 3 months ago

    In order to eliminate the potential cause being the file itself, I have used the sample file from github.

    On the upload CSV file tabe:
    When I select the file – NOTHING else happens – it doesn’t appear to upload in any way, it doesn’t progress to the column mapping tab, and it doesn’t give any error message.

    It just… nothings.

    screen image: https://pasteboard.co/zSw6pRMTMmdW.jpg

    I’d appreciate some help / suggestions as to how to fix this please.

    `
### WordPress Environment ###

WordPress address (URL): https://traxide.com.au
Site address (URL): https://traxide.com.au
WC Version: 7.9.0
REST API Version: ? 7.9.0
WC Blocks Version: ? 10.4.6
Action Scheduler Version: ? 3.6.1
Log Directory Writable: ?
WP Version: 6.2.2
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_AU
External object cache: –

### Server Environment ###

Server Info: LiteSpeed
PHP Version: 8.0.29
PHP Post Max Size: 128 MB
PHP Time Limit: 300
PHP Max Input Vars: 3000
cURL Version: 7.87.0
OpenSSL/1.1.1p

SUHOSIN Installed: –
MySQL Version: 10.6.14-MariaDB
Max Upload Size: 128 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ? Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.
DOMDocument: ?
GZip: ?
Multibyte String: ? Your server does not support the mbstring functions - this is required for better character encoding. Some fallbacks will be used instead for it.
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 7.9.0
WC Database Prefix: 8d3uv_
Total Database Size: 5.95MB
Database Data Size: 5.28MB
Database Index Size: 0.67MB
8d3uv_woocommerce_sessions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_woocommerce_order_itemmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_actionscheduler_actions: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
8d3uv_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
8d3uv_actionscheduler_logs: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
8d3uv_commentmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
8d3uv_comments: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
8d3uv_ic_sessions: Data: 0.57MB + Index: 0.31MB + Engine MyISAM
8d3uv_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_litespeed_url: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_litespeed_url_file: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_mgmlp_folders: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_options: Data: 1.49MB + Index: 0.07MB + Engine MyISAM
8d3uv_pmxi_files: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_pmxi_hash: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_pmxi_history: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_pmxi_images: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
8d3uv_pmxi_imports: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_pmxi_posts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_pmxi_templates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_postmeta: Data: 0.54MB + Index: 0.08MB + Engine MyISAM
8d3uv_posts: Data: 2.56MB + Index: 0.06MB + Engine MyISAM
8d3uv_rank_math_internal_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_rank_math_internal_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_rich_web_font_family: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_rich_web_forms_cust_id: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_rich_web_forms_fields: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
8d3uv_rich_web_forms_id: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_rich_web_forms_info: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_rich_web_forms_mails: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_rich_web_forms_manager: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_rich_web_forms_options: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_rich_web_forms_saved: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_rich_web_forms_themes1: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_rich_web_forms_themes2: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_rich_web_forms_themes3: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_rich_web_icons: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
8d3uv_rich_web_timeline_manager: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_rich_web_timeline_options: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_rich_web_timeline_short_options: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_rich_web_timeline_style_options: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_rich_web_timeline_style_options_2: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_termmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
8d3uv_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
8d3uv_term_relationships: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
8d3uv_term_taxonomy: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_usermeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
8d3uv_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
8d3uv_wc_admin_notes: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
8d3uv_wc_admin_note_actions: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
8d3uv_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_wc_customer_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_wc_order_product_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_wc_order_stats: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_wc_product_attributes_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_wc_product_download_directories: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
8d3uv_wc_product_meta_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_wc_rate_limits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
8d3uv_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
8d3uv_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

### Post Type Counts ###

al_digital_orders: 56
al_product: 33
attachment: 158
custom_css: 1
et_body_layout: 1
et_footer_layout: 3
et_header_layout: 1
et_template: 10
et_theme_builder: 1
mgmlp_media_folder: 22
nav_menu_item: 6
page: 12
post: 1
revision: 108
wp_global_styles: 2

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (7) ###

3D FlipBook : Dflip Lite: by DearHive – 1.7.35
eCommerce Product Catalog for WordPress: by impleCode – 3.3.18
LiteSpeed Cache: by LiteSpeed Technologies – 5.5.1
Product Enquiry for WooCommerce: by WisdmLabs – 3.1.6
Really Simple SSL: by Really Simple Plugins – 7.0.7
Rank Math SEO: by Rank Math – 1.0.120
WooCommerce: by Automattic – 7.9.0

### Inactive Plugins (3) ###

Duplicate Page: by mndpsingh287 – 4.5.2
Mailer Dragon: by impleCode – 1.1.2
Reviews Plus - Google compatible WordPress Reviews for any content: by impleCode – 1.3.3

### Dropin Plugins (1) ###

maintenance.php: maintenance.php

### Settings ###

API Enabled: –
Force SSL: –
Currency: AUD ($)
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: –
HPOS feature screen enabled: –
HPOS feature enabled: –
Order datastore: WC_Order_Data_Store_CPT
HPOS data sync enabled: –

### WC Pages ###

Shop base: ? Page not set
Cart: ? Page not set
Checkout: ? Page not set
My account: ? Page not set
Terms and conditions: ? Page not set

### Theme ###

Name: Divi Child Theme
Version: 1.0
Author URL: https://divilover.com
Child Theme: ?
Parent Theme Name: Divi
Parent Theme Version: 4.21.1
Parent Theme Author URL: https://www.elegantthemes.com
WooCommerce Support: ?

### Templates ###

Overrides: –

### Admin ###

Enabled Features: activity-panels
analytics
product-block-editor
coupons
core-profiler
customer-effort-score-tracks
import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
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
async-product-editor-category-field

Daily Cron: ? Next scheduled: 2023-08-02 08:23:52 +10:00
Options: ?
Notes: 82
Onboarding: completed

### Action Scheduler ###

Complete: 64
Oldest: 2023-07-31 23:05:21 +0000
Newest: 2023-08-01 23:24:38 +0000

Failed: 2
Oldest: 2023-07-31 23:13:48 +0000
Newest: 2023-08-01 11:45:05 +0000

Pending: 1
Oldest: 2023-08-02 23:24:38 +0000
Newest: 2023-08-02 23:24:38 +0000


### Status report information ###

Generated at: 2023-08-02 14:48:25 +10:00
`
Viewing 8 replies - 1 through 8 (of 8 total)

  • Hi @landyvlad,

    Thanks for sharing a screenshot and System status. Based on the screenshot, it looks like the ‘Continue’ button is missing from your Import page. Here is a screenshot of my test website’s Product Import page for reference: https://snipboard.io/DB72nL.jpg

    Try switching your theme to Storefront, disable all plugins except WooCommerce and then try to import products and let us know if that works.

    Thread Starter LandyVlad

    (@landyvlad)

    Yep that’s exactly whats missing )OK I’ll find and install the storefront theme and see how I go. It’s on a live website so I hope it’s a quick process to do imports?

    Thread Starter LandyVlad

    (@landyvlad)

    Sadly no luck.

    I have tried all convolutions of the above suggestion.

    • (existing) Divi theme, all plugins bar woocommerce enabled.
    • Divi theme, all plugins bar woocommerce disabled.
    • Storefront theme, all plugins bar woocommerce disabled.

    Still exactly the same behaviour as per my original post.

    It’s very frustrating for sure – any other ideas?

    Could these things have anything to do with it? Perhaps someone can explain them to me? On the face of it, it doesn’t appear to me that either of these would or could cause the issue I am experiencing. 

    SoapClient: ? Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.

Multibyte String: ? Your server does not support the mbstring functions - this is required for better character encoding. Some fallbacks will be used instead for it.
    Thread Starter LandyVlad

    (@landyvlad)

    For additional information which may be relevant.
    Further to the above I found a thread on this same problem here

    That person managed to resolve the issue (at their host) as follows:
    ” … php8.0… some php packages were not installed for that version the package I needed was mb_detect_encoding this is for giving php the capabilties to process CSV information. I had to enable and install it on WHM – cPanel. The package on whm is called php80-php-mbstring.”

    I looked in what I thought was the appropriate place – PHP PEAR packages.
    I searched for the package php80-php-mbstring – not found.
    Searched for variations of that: php80-php & php-mbstring & mbstring – none found.

    Tried to install it anyway –
    parsePackageName(): only one version/state delimiter “-” is allowed in “php80-php-mbstring”
    invalid package name/package file “php80-php-mbstring”
    install failed

    Also searched for mb_detect_encoding but couldn’t find anything with that name either.

    I contacted my hosting provider who stated that “The mbstring PHP 8.0 extension and by extension the mb_detect_encoding function is installed. GD, which is sometimes a requirement, is also enabled.”

    So now what? Suggestions?

    What’s your hosting environment?

    In cPanel, you can enable PHP extensions by yourself without installing them, in case they are disabled. Search for “Select PHP”.

    Ultimately, you should check which extensions are active using phpinfo(). Just upload a file with this function in it and run it from your browser. Once the configuration is correct, this will show it to you. Just copy and paste this:

    <?php phpinfo(); ?>
    Thread Starter LandyVlad

    (@landyvlad)

    OK so I found out that the site is actually hosted somewhere different to what I thought – there were duplicate accounts but only one with the DNS pointing to it.

    I’m trying to access that and transfer it to my own hosting to sort this out!

    Thanks for your help so far I’ll report back how it finally works out for future reference. ??

    Thread Starter LandyVlad

    (@landyvlad)

    Having changed hosting this issue is resolved.

    Thank you for your assistance.

    However I now have another (unrelated one) but I’ll post a new thread on that ( https://www.ads-software.com/support/topic/failed-import-catalogue-visibility/ )

    Hi @landyvlad

    The new thread seems to also have been fixed. Glad that you found a solution.

    I’m going to mark this thread as resolved, but please don’t hesitate to start a new topic if you have any more questions down the line.

    Have a fantastic day!

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Unable to upload a products csv file’ is closed to new replies.