The link you followed has expired
-
I have searched for hours for a solution to uploading a csv file of products to WooCommerce. I am using woo commerce 3.64 and wordpress 5.2.1. I switched to the generic 2019 theme to see if it would upload there, but it didn’t. I installed a MIME plug in (although my error never mentioned security issues). I changed the limits in the php file, switched the file to txt instead of csv, uploaded it directly to the server, but nothing works.
-
Can you please submit a system report. Goto woocommerce > status > get system report
Paste that here
### WordPress Environment ### WordPress address (URL): https://www.woodhouseknits.com Site address (URL): https://www.woodhouseknits.com WC Version: 3.6.4 Log Directory Writable: ? WP Version: 5.2.1 WP Multisite: – WP Memory Limit: 512 MB WP Debug Mode: – WP Cron: ? Language: en_US External object cache: – ### Server Environment ### Server Info: Apache/2 PHP Version: 7.1.1 - We recommend using PHP version 7.2 or above for greater performance and security. How to update your PHP version PHP Post Max Size: 32 MB PHP Time Limit: 180 PHP Max Input Vars: 1000 cURL Version: 7.47.0 GnuTLS/3.4.10 SUHOSIN Installed: – MySQL Version: 5.6.41-84.1-log Max Upload Size: 32 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: ? Remote Post: ? Remote Get: ? ### Database ### WC Database Version: 3.6.4 WC Database Prefix: wp_ MaxMind GeoIP Database: ? Total Database Size: 13.39MB Database Data Size: 11.39MB Database Index Size: 2.00MB wp_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.05MB wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB wp_bwg_album: Data: 0.02MB + Index: 0.00MB wp_bwg_album_gallery: Data: 0.02MB + Index: 0.00MB wp_bwg_gallery: Data: 0.02MB + Index: 0.00MB wp_bwg_image: Data: 0.02MB + Index: 0.00MB wp_bwg_image_comment: Data: 0.02MB + Index: 0.00MB wp_bwg_image_rate: Data: 0.02MB + Index: 0.00MB wp_bwg_image_tag: Data: 0.02MB + Index: 0.00MB wp_bwg_option: Data: 0.02MB + Index: 0.00MB wp_bwg_shortcode: Data: 0.02MB + Index: 0.00MB wp_bwg_theme: Data: 0.05MB + Index: 0.00MB wp_cjtoolbox_authors: Data: 0.02MB + Index: 0.03MB wp_cjtoolbox_backups: Data: 0.02MB + Index: 0.02MB wp_cjtoolbox_blocks: Data: 0.02MB + Index: 0.03MB wp_cjtoolbox_block_files: Data: 0.02MB + Index: 0.00MB wp_cjtoolbox_block_pins: Data: 0.02MB + Index: 0.00MB wp_cjtoolbox_block_templates: Data: 0.02MB + Index: 0.00MB wp_cjtoolbox_forms: Data: 0.02MB + Index: 0.00MB wp_cjtoolbox_form_groups: Data: 0.02MB + Index: 0.03MB wp_cjtoolbox_form_group_parameters: Data: 0.02MB + Index: 0.02MB wp_cjtoolbox_form_group_xfields: Data: 0.02MB + Index: 0.00MB wp_cjtoolbox_packages: Data: 0.02MB + Index: 0.00MB wp_cjtoolbox_package_objects: Data: 0.02MB + Index: 0.00MB wp_cjtoolbox_parameters: Data: 0.02MB + Index: 0.05MB wp_cjtoolbox_parameter_typedef: Data: 0.02MB + Index: 0.02MB wp_cjtoolbox_parameter_typeparams: Data: 0.02MB + Index: 0.02MB wp_cjtoolbox_templates: Data: 0.05MB + Index: 0.11MB wp_cjtoolbox_template_revisions: Data: 0.06MB + Index: 0.02MB wp_commentmeta: Data: 0.01MB + Index: 0.01MB wp_comments: Data: 0.04MB + Index: 0.03MB wp_FinalTiles_gallery: Data: 0.02MB + Index: 0.00MB wp_FinalTiles_gallery_images: Data: 0.02MB + Index: 0.00MB wp_gallery_galleries: Data: 0.00MB + Index: 0.00MB wp_gallery_galleriesslides: Data: 0.00MB + Index: 0.00MB wp_gallery_slides: Data: 0.00MB + Index: 0.00MB wp_huge_itportfolio_images: Data: 0.02MB + Index: 0.02MB wp_huge_itportfolio_portfolios: Data: 0.02MB + Index: 0.02MB wp_links: Data: 0.00MB + Index: 0.00MB wp_nf3_actions: Data: 0.02MB + Index: 0.00MB wp_nf3_action_meta: Data: 0.02MB + Index: 0.00MB wp_nf3_chunks: Data: 0.02MB + Index: 0.00MB wp_nf3_fields: Data: 0.02MB + Index: 0.00MB wp_nf3_field_meta: Data: 0.05MB + Index: 0.00MB wp_nf3_forms: Data: 0.02MB + Index: 0.00MB wp_nf3_form_meta: Data: 0.02MB + Index: 0.00MB wp_nf3_objects: Data: 0.02MB + Index: 0.00MB wp_nf3_object_meta: Data: 0.02MB + Index: 0.00MB wp_nf3_relationships: Data: 0.02MB + Index: 0.00MB wp_nf3_upgrades: Data: 0.02MB + Index: 0.00MB wp_ngg_album: Data: 0.02MB + Index: 0.02MB wp_ngg_gallery: Data: 0.02MB + Index: 0.02MB wp_ngg_pictures: Data: 0.02MB + Index: 0.02MB wp_options: Data: 1.62MB + Index: 0.10MB wp_postmeta: Data: 3.86MB + Index: 0.25MB wp_posts: Data: 4.22MB + Index: 0.27MB wp_termmeta: Data: 0.02MB + Index: 0.03MB wp_terms: Data: 0.00MB + Index: 0.01MB wp_term_relationships: Data: 0.05MB + Index: 0.10MB wp_term_taxonomy: Data: 0.00MB + Index: 0.01MB wp_usermeta: Data: 0.01MB + Index: 0.01MB wp_users: Data: 0.00MB + Index: 0.01MB wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB wp_wc_download_log: Data: 0.02MB + Index: 0.03MB wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB wp_wprss_logs: Data: 0.05MB + Index: 0.00MB ### Post Type Counts ### attachment: 1403 bwg_album: 1 bwg_gallery: 2 customize_changeset: 4 ml-slide: 20 ml-slider: 2 nav_menu_item: 5 page: 21 post: 230 product: 13 revision: 1152 scheduled-action: 42 wprss_feed: 1 wprss_feed_item: 97 wprss_feed_template: 1 ### Security ### Secure connection (HTTPS): ? Your store is not using HTTPS. Learn more about HTTPS and SSL Certificates. Hide errors from visitors: ? ### Active Plugins (23) ### Better Internal Link Search: by Cedaro – 1.3.0 Contact Form 7 MailChimp Extension: by Renzo Johnson – 0.4.51 Contact Form 7: by Takayuki Miyoshi – 5.1.3 CSS & JavaScript Toolbox: by Wipeout Media – 8.4.2 Disable Real MIME Check: by Sergey Biryukov – 1.0 Forget About Shortcode Buttons: by Designs & Code – 2.1.2 Genesis eNews Extended: by Brandon Kraft – 2.1.1 Genesis Featured Page Advanced: by Nick Diego – 1.9.6 Genesis Responsive Slider: by StudioPress – 1.0.0 Genesis Simple Share: by StudioPress – 1.1.4 Google Analytics Dashboard for WP (GADWP): by ExactMetrics – 5.3.8 Anti-Malware Security and Brute-Force Firewall: by Eli Scheetz – 4.18.74 Instagram Feed: by Smash Balloon – 1.12 Internal Link Widget: by Martino Stenta – 0.3 Jetpack by WordPress.com: by Automattic – 7.4 MetaSlider: by Team Updraft – 3.13.1 Ninja Forms: by The WP Ninjas – 3.4.13 Page Links To: by Mark Jaquith – 3.1.1 Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.1 UpdraftPlus - Backup/Restore: by UpdraftPlus.Com DavidAnderson – 1.16.15 Widget Importer & Exporter: by ChurchThemes.com – 1.5.5 WooCommerce: by Automattic – 3.6.4 WP RSS Aggregator: by RebelCode – 4.13.2 ### Inactive Plugins (9) ### Disqus for WordPress: by Disqus – 3.0.17 Enable Media Replace: by ShortPixel – 3.3.0 Facebook Members: by Crunchify – 8.0 Genesis Connect for WooCommerce: by StudioPress – 1.0 – Not tested with the active version of WooCommerce Maintenance Mode: by Michael W?hrer – 5.4 Media Library Assistant: by David Lingren – 2.79 Ravelry Designs Widget: by Shellbot – 1.0.0 WooCommerce Admin: by WooCommerce – 0.12.0 WP Super Cache: by Automattic – 1.6.7 ### Settings ### API Enabled: – Force SSL: – Currency: USD ($) 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 ### Shop base: #3371 - /shop/ Cart: #3372 - /cart/ Checkout: #3373 - /checkout/ My account: #3374 - /my-account/ Terms and conditions: ? Page not set ### Theme ### Name: Amelia Version: 2.1.0 Author URL: https://17thavenuedesigns.com Child Theme: ? Parent Theme Name: Genesis Parent Theme Version: 2.10.1 Parent Theme Author URL: https://www.studiopress.com/ WooCommerce Support: ? Not declared ### Templates ### Overrides: – ### Action Scheduler ### Complete: 40 Oldest: 2019-06-10 19:49:00 +0000 Newest: 2019-06-11 10:23:24 +0000 Pending: 1 Oldest: 2019-06-11 11:23:24 +0000 Newest: 2019-06-11 11:23:24 +0000 Canceled: 1 Oldest: 2019-06-11 01:42:09 +0000 Newest: 2019-06-11 01:42:09 +0000 In-progress: 0 Oldest: – Newest: – Failed: 0 Oldest: – Newest: –
Thank you for that.
I also should have asked that you submit your CSV file too. You can upload and share via Share CSV
We need to see how you’re mapping the file.
Thank you. Your headings are mislabeled. Don’t use uppercase and you have to use an underscore for spaces.
Please see a sample CSV add one product based on this and if you have success then add all your products.
Ah. I downloaded the csv directly from products I had entered manually and didn’t think about the column headings being changed. Bad news: it still didn’t work. I am using the unpaid woo commerce at the moment. I was under the impression I should be using these headings: https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Import-Schema#csv-columns-and-formatting
I attempted uploading the sample csv, and it said link was expired, too. Here is the updated csv.
https://www.sharecsv.com/s/9a1b7016877dd685cbda855ad194a479/import2.csvThat’s our own csv so it has to be something you’re adding to it that’s making it not take or permissions are incorrect on your server.
What did you change on the sample form?
I didn’t change anything on the sample.
Then something else is wrong. You must have a permission restriction on the server or something.
-
This reply was modified 5 years, 9 months ago by
Stef.
Hi @mda345,
Just to make sure I understand this correctly: When you try to import a CSV file on your site, you are given the error “The link you followed has expired”. Is that correct?
If so, can you confirm how are you importing the CSV file? Is it through the built-in importer tool located in the Products screen of the Dashboard?
If that’s the case, and you are unable to upload even the unmodified sample CSV file, the issue is likely not with the file but elsewhere on the site. There are two things I’d suggest you test:
1. Try creating a brand new administrator account on the site, and then attempt to import the file again while logged in to this new account. Just to make sure the issue does not lay with the permissions of the account you are currently using.
2. If that doesn’t work, I’d then recommend trying a conflict test. This would require you to switch your site’s theme to the free Storefront theme, and then disable ALL plugins on your site except for WooCommerce. Under this setup, try to upload the file again.
Hopefully this shines some light on the issues!
We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.
-
This reply was modified 5 years, 9 months ago by
- The topic ‘The link you followed has expired’ is closed to new replies.