Jili 646 777 real money withdrawal.REGISTER NOW GET FREE 888 PESOS REWARDS!

Resolved

(@waltlin1)

Hello folks! I’m currently having issues with the default product import in WooCommerce 8.5.2. I’m trying to use a CSV file to import products that are exclusively external / affiliate products. Accordingly, each product has an external URL (product_url), which is also specified in the corresponding column in the CSV. The URL is also recognized in the field mapping during import, but it cannot be found in the field provided on the product page after the import. I have already changed the default product type to “external / affiliate” in functions.php.

What I have tried so far:

WC rollback to version 7.0.0
WP debug mode
encoding the URLs in the CSV file
Changing the website language from German to English

WP has the current version. Thanks in advance for your help!

————————————————————–

` WordPress Environment

WordPress address (URL): https://staging-nemnn3b8fk.live-website.com
Site address (URL): https://staging-nemnn3b8fk.live-website.com
WC Version: 8.5.2
REST API Version: ? 8.5.2
WC Blocks Version: ? 11.8.0-dev
Action Scheduler Version: ? 3.7.1
Log Directory Writable: ?
WP Version: 6.4.3
WP Multisite: –
WP Memory Limit: ? 40 MB - Wir empfehlen das PHP Speicher-Limit (memory_limit) auf mindestens 64 MB zu setzen. Siehe: PHP Speicher-Limit erh?hen
WP Debug Mode: –
WP Cron: –
Language: de_DE
External object cache: – Server Environment

Server Info: Apache
PHP Version: 8.1.27
PHP Post Max Size: 64 MB
PHP Time Limit: 50000
PHP Max Input Vars: 5000
cURL Version: 7.74.0
OpenSSL/1.1.1w

SUHOSIN Installed: –
MySQL Version: 10.6.15-MariaDB-log
Max Upload Size: 64 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ? Database

WC Database Version: 7.0.0
WC Database Prefix: tbur_
Datenbank-Gesamtgr??e: 29.60MB
Datenbank-Datengr??e: 20.98MB
Datenbank-Indexgr??e: 8.62MB
tbur_woocommerce_sessions: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
tbur_woocommerce_api_keys: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
tbur_woocommerce_attribute_taxonomies: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
tbur_woocommerce_downloadable_product_permissions: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB
tbur_woocommerce_order_items: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
tbur_woocommerce_order_itemmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
tbur_woocommerce_tax_rates: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB
tbur_woocommerce_tax_rate_locations: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
tbur_woocommerce_shipping_zones: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
tbur_woocommerce_shipping_zone_locations: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
tbur_woocommerce_shipping_zone_methods: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
tbur_woocommerce_payment_tokens: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
tbur_woocommerce_payment_tokenmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
tbur_woocommerce_log: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
tbur_actionscheduler_actions: Daten: 2.52MB + Index: 2.72MB + Engine InnoDB
tbur_actionscheduler_claims: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
tbur_actionscheduler_groups: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
tbur_actionscheduler_logs: Daten: 1.52MB + Index: 1.84MB + Engine InnoDB
tbur_commentmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
tbur_comments: Daten: 0.02MB + Index: 0.09MB + Engine InnoDB
tbur_gla_attribute_mapping_rules: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
tbur_gla_budget_recommendations: Daten: 0.19MB + Index: 0.14MB + Engine InnoDB
tbur_gla_merchant_issues: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
tbur_gla_shipping_rates: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
tbur_gla_shipping_times: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
tbur_links: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
tbur_options: Daten: 4.05MB + Index: 0.06MB + Engine InnoDB
tbur_piecfw_product_import_cron: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
tbur_piecfw_product_import_data_log: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
tbur_piecfw_product_import_file_log: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
tbur_postmeta: Daten: 3.41MB + Index: 2.17MB + Engine InnoDB
tbur_posts: Daten: 1.11MB + Index: 0.23MB + Engine InnoDB
tbur_termmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
tbur_terms: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
tbur_term_relationships: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
tbur_term_taxonomy: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
tbur_usermeta: Daten: 7.02MB + Index: 0.03MB + Engine InnoDB
tbur_users: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB
tbur_wc_admin_notes: Daten: 0.06MB + Index: 0.00MB + Engine InnoDB
tbur_wc_admin_note_actions: Daten: 0.05MB + Index: 0.02MB + Engine InnoDB
tbur_wc_category_lookup: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
tbur_wc_customer_lookup: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
tbur_wc_download_log: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
tbur_wc_orders: Daten: 0.02MB + Index: 0.11MB + Engine InnoDB
tbur_wc_orders_meta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
tbur_wc_order_addresses: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB
tbur_wc_order_coupon_lookup: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
tbur_wc_order_operational_data: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
tbur_wc_order_product_lookup: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB
tbur_wc_order_stats: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB
tbur_wc_order_tax_lookup: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
tbur_wc_product_attributes_lookup: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
tbur_wc_product_download_directories: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
tbur_wc_product_meta_lookup: Daten: 0.02MB + Index: 0.09MB + Engine InnoDB
tbur_wc_rate_limits: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
tbur_wc_reserved_stock: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
tbur_wc_tax_rate_classes: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
tbur_wc_webhooks: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
tbur_wt_iew_action_history: Daten: 0.05MB + Index: 0.00MB + Engine InnoDB
tbur_wt_iew_mapping_template: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB Post Type Counts

attachment: 762
page: 8
post: 2
product: 103
revision: 1
wp_global_styles: 1
wp_navigation: 1
wp_template: 2 Security

Secure connection (HTTPS): ?
Hide errors from visitors: ? Active Plugins (2)

IONOS Login: von IONOS – 2.2.1
WooCommerce: von Automattic – 8.5.2 Inactive Plugins (10)

CSV Product Import Export for WooCommerce: von cmssoft – 1.0.0
Google Listings and Ads: von WooCommerce – 2.5.16
IONOS Assistant: von IONOS – 8.5.10
IONOS Help: von IONOS – 2.2.1
IONOS Journey: von IONOS – 2.1.1
IONOS Navigation: von IONOS – 1.0.7
IONOS Performance: von IONOS – 2.0.3
IONOS Security: von IONOS – 1.1.0
Pinterest for WooCommerce: von WooCommerce – 1.3.20
Product Import Export for WooCommerce: von WebToffee – 2.4.0 Must Use Plugins (2)

IONOS Marketplace: von IONOS – 1.1.6
WordPress automation by Installatron: von – Settings

API Enabled: –
Force SSL: –
Currency: EUR (€)
Currency Position: right_space
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 Woo.com: –
Enforce Approved Product Download Directories: ?
HPOS feature screen enabled: ?
HPOS feature enabled: ?
Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore
HPOS data sync enabled: – WC Pages

Shop-Basis: #7 - /shop/
Warenkorb: #8 - /warenkorb/
Kasse: #9 - /kasse/
Mein Konto: #10 - /mein-konto/
Allgemeine Gesch?ftsbedingungen: ? Seite nicht festgelegt Theme

Name: Twenty Twenty-Four
Version: 1.0
Author URL: https://de.www.ads-software.com
Child Theme: ? – Wenn du WooCommerce mit einem Theme
das du nicht selbst entwickelt hast
an eigene Bedürfnisse anpasst
dann empfehlen wir die Verwendung eines Child-Themes. Siehe Wie du ein Child-Theme erstellst (engl.)

WooCommerce Support: ? Nicht deklariert 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
product-variation-management
product-virtual-downloadable
product-external-affiliate
product-grouped
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: customize-store
minified-js
new-product-management-experience
product-linked
settings
async-product-editor-category-field

Daily Cron: ? Next scheduled: 2024-02-01 15:32:15 +00:00
Options: ?
Notes: 64
Onboarding: completed Action Scheduler

Abgeschlossen: 5.478
Oldest: 2024-01-31 11:39:30 +0000
Newest: 2024-02-01 09:42:14 +0000

Ausstehend: 4
Oldest: 2024-02-01 09:42:33 +0000
Newest: 2024-02-01 11:39:30 +0000

Fehlgeschlagen: 1
Oldest: 2024-01-31 11:47:59 +0000
Newest: 2024-01-31 11:47:59 +0000 Status report information

Generated at: 2024-02-01 09:42:15 +00:00
`

This topic was modified 8 months, 3 weeks ago by waltlin1.

Viewing 1 replies (of 1 total)

carolm29 (woo-hc)
(@carolm29)

8 months, 3 weeks ago
Hey there, @waltlin1! Thanks for contacting us. I’m happy to help you.

It seems like you’ve already taken several steps to troubleshoot the issue. Let’s try to narrow down the problem and see if we can find a solution. Here are a few more suggestions:
1. CSV File Format:
  - Ensure that the CSV file is formatted correctly. Check if the product_url column header matches exactly with how WooCommerce recognizes it. It’s case-sensitive, and any mismatch could cause issues.
2. CSV Column Mapping:
  - Double-check the column mapping during the import process. Make sure that the product_url column in your CSV file is correctly mapped to the External/Affiliate Product URL field in the import settings.
3. Column Data Format:
  - Confirm that the URLs in the product_url column of your CSV file are in the correct format. They should be complete URLs (e.g., https://example.com/product-page).
4. CSV File Content:
  - Open the CSV file in a text editor and verify that the product_url values are present and correctly formatted.
5. Product Type Setting:
  - Even though you’ve set the default product type to “external/affiliate” in functions.php, ensure that it hasn’t changed during the import process. Sometimes, the import settings can override default settings.
6. Import Logs:
  - Check for any error logs or messages generated during the import process. These logs might provide additional details about what could be going wrong.
7. Theme and Plugin Conflicts:
  - Temporarily switch to a default WordPress theme (like Storefront) and deactivate other plugins. Then, attempt the import again to check if there might be a conflict causing the issue.
Furthermore, I’d like to understand your site properly. Please share with us the necessary information below for us to investigate the issue further:

System Status Report which you can find via WooCommerce > Status > Get system report > Copy for support.
Fatal error logs (if any) under WooCommerce > Status > Logs.
You could copy and paste your reply here or paste it via https://gist.github.com/ and send the link here.

And lastly, I noticed your memory limit is currently below the minimum recommended of 64 MB. Can you please increase it to avoid future issues?

Looking forward to your reply.

Have a wonderful day!

Viewing 1 replies (of 1 total)

The topic ‘External URL is not imported when importing with a CSV file’ is closed to new replies.

Tags