• Resolved mda345

    (@mda345)


    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.

Viewing 11 replies - 1 through 11 (of 11 total)
  • Stef

    (@serafinnyc)

    Can you please submit a system report. Goto woocommerce > status > get system report

    Paste that here

    Thread Starter mda345

    (@mda345)

    
    ### 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: –
    
    
    Stef

    (@serafinnyc)

    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.

    Thread Starter mda345

    (@mda345)

    Stef

    (@serafinnyc)

    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.

    Thread Starter mda345

    (@mda345)

    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.csv

    Stef

    (@serafinnyc)

    That’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?

    Thread Starter mda345

    (@mda345)

    I didn’t change anything on the sample.

    Stef

    (@serafinnyc)

    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.
    Plugin Support Fernando a11n

    (@fhaps)

    Automattic Happiness Engineer

    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!

    Plugin Support Fernando a11n

    (@fhaps)

    Automattic Happiness Engineer

    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.

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘The link you followed has expired’ is closed to new replies.