CSV Import Attaching Datasheets

  • Resolved spectrad

    (@spectrad)


    4 years, 10 months ago

    I am attempting to create a product csv to import which includes datasheets (which I have uploaded to my shop) is it possible to do this?

    The product import csv examples don’t seem to allow this, I have tried using the download field, but can’t seem to get this to work either.

    If I manually add datasheets, will it remove them if I update the CSV import later on?

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Support Kel C. a11n

    (@kellymetal)

    4 years, 10 months ago

    Hi there,

    Please explain a bit more about what you mean when you say “datasheets”.

    Are you referring to spreadsheet files that you want to attach as downloadable files for the product? If so, you can include the URL and name of the file, as shown with the example in the import CSV schema here:
    https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Import-Schema#csv-columns-and-formatting

    I’d also recommend reading through the documentation for the importer here:
    https://docs.woocommerce.com/document/product-csv-importer-exporter/

    If the files were going to be hosted on the site, you will need to upload them to the site first, then add the URL to the CSV. If they are hosted elsewhere, you can just include the external URL.

    If you meant something different, please explain more about what you are trying to do.

    Thread Starter spectrad

    (@spectrad)

    4 years, 10 months ago

    Hi

    Thanks for replying, I will try to explain better…

    By datasheets, I mean a product .pdf – we sell professional audio kit, the manufacturers supply us with pdf data sheets for each product, so as well as our short and long descriptions, I also want to include the technical datasheet on the product as a download. I can add these easily to media using add new and dragging and dropping, but which field do I add them to in the csv? I have tried Download 1 URL but nothing appears on the product webpage.

    Hopefully that makes more sense?

    Plugin Support Kel C. a11n

    (@kellymetal)

    4 years, 10 months ago

    Hi there,

    Thank you for the information — yes, that makes more sense!

    From your mention of “nothing appears on the product webpage”, I see that you are trying to get the PDF to show up on the product page itself.

    The Download 1 URL column in the CSV would be for if you want to include the file as a download after the customer purchases the product. It sounds like you want to do this as well, however it would not appear on the actual product page — just the Thank You page and emails after the purchase.

    If you wanted to include a link to the PDF file on the product page as well, you could include that in the Short Description or Description columns of the CSV. Then it would appear in one of the places here (the specific place/display would depend on your site’s theme):

    Product description
    Link to image: https://d.pr/i/IMXFxc

    Does that clarify things? Please let me know if that is still different from what you were trying to do.

    Thread Starter spectrad

    (@spectrad)

    4 years, 10 months ago

    Hi

    Thanks again for the reply, you are nearly correct.

    I would like a download datasheet button on the product page, if I manually add a product and add the data sheet to that product, at the bottom of the page I get multiple tabs:

    Description
    Technical
    Downloads

    the downloads tab contains any pdf datasheets I have added.

    I want to do similar, but using the CSV to import the product.

    Plugin Support Kel C. a11n

    (@kellymetal)

    4 years, 10 months ago

    Hi there,

    By default, on the product page WooCommerce core only includes tabs for Description, Additional Information (containing info like weight, dimensions, attributes), and Reviews (if enabled on the site). However, it doesn’t have any “Technical” or “Downloads” tabs, so those are likely being added by a plugin you have installed on your site, or possibly your theme.

    The specific method of importing that data would depend on how that plugin/theme is adding those. If you know what you are using that is adding those tabs, please reach out to the team behind the plugin/theme to ask about this.

    If you are unsure, please share a copy of your site’s System Status. 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 here in your reply. Please note that since this is a public forum, you may want to remove any sensitive information that you don’t want shared publicly.

    Thread Starter spectrad

    (@spectrad)

    4 years, 10 months ago

    Hi

    This is running on a test environment at the moment, it was created by a developer for us hence me not knowing much about it.

    Hopefully I have removed any sensitive information?

    
### WordPress Environment ###

WordPress address (URL): 
Site address (URL): 
WC Version: 5.1.1
REST API Version: ✔ 5.1.1
WC Blocks Version: ✔ 4.4.3
Action Scheduler Version: ✔ 3.1.6
WC Admin Version: ✔ 2.4.4
Log Directory Writable: ✔
WP Version: ❌ 5.7.2 - There is a newer version of WordPress available (5.8)
WP Multisite: –
WP Memory Limit: 128 MB
WP Debug Mode: –
WP Cron: ✔
Language: en_GB
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.3.29
PHP Post Max Size: 128 MB
PHP Time Limit: 60
PHP Max Input Vars: 2500
cURL Version: 7.65.0
OpenSSL/1.0.2k-fips

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.2.33-MariaDB-log
Max Upload Size: 128 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔

### Database ###

WC Database Version: 5.1.1
WC Database Prefix: wp_
Total Database Size: 40.94MB
Database Data Size: 31.61MB
Database Index Size: 9.33MB
wp_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Data: 0.06MB + Index: 0.11MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_cms2cms_connector_options: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mw_wc_qbo_sync_customer_pairs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mw_wc_qbo_sync_log: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
wp_mw_wc_qbo_sync_paymentmethod_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mw_wc_qbo_sync_payment_id_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mw_wc_qbo_sync_product_pairs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mw_wc_qbo_sync_qbo_customers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mw_wc_qbo_sync_qbo_items: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_mw_wc_qbo_sync_real_time_sync_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mw_wc_qbo_sync_real_time_sync_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mw_wc_qbo_sync_shipping_product_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mw_wc_qbo_sync_tax_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mw_wc_qbo_sync_variation_pairs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mw_wc_qbo_sync_wq_cf_map: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_options: Data: 4.02MB + Index: 0.14MB + Engine InnoDB
wp_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_images: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_imports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_posts: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_postmeta: Data: 10.08MB + Index: 5.52MB + Engine InnoDB
wp_posts: Data: 9.09MB + Index: 0.86MB + Engine InnoDB
wp_quform_entries: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_quform_entry_data: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_quform_entry_entry_labels: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_quform_entry_labels: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_quform_forms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_quform_sessions: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wp_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wp_revslider_css_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_sliders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_sliders_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_slides: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wp_revslider_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_termmeta: Data: 0.06MB + Index: 0.06MB + Engine InnoDB
wp_terms: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 0.38MB + Index: 0.20MB + Engine InnoDB
wp_term_taxonomy: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_usermeta: Data: 0.09MB + Index: 0.03MB + Engine InnoDB
wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.23MB + Index: 0.36MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wpmelon_advbedit_temp: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_yoast_indexable: Data: 2.52MB + Index: 0.64MB + Engine InnoDB
wp_yoast_indexable_hierarchy: Data: 0.05MB + Index: 0.05MB + Engine InnoDB
wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_yoast_seo_links: Data: 0.25MB + Index: 0.16MB + Engine InnoDB
wp_yoast_seo_meta: Data: 0.23MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

attachment: 1430
customize_changeset: 4
etheme_portfolio: 6
nav_menu_item: 248
oembed_cache: 27
page: 150
post: 26
product: 1245
product_variation: 943
revision: 802
shop_order: 1
staticblocks: 4
vc_grid_item: 1
was: 13
ywdpd_discount: 7

### Security ###

Secure connection (HTTPS): ❌
					Your store is not using HTTPS. Learn more about HTTPS and SSL Certificates.
Hide errors from visitors: ✔

### Active Plugins (29) ###

Redux: by Redux.io + Dovy Paukstys – 4.1.17
Bulk Page Creator: by Dagan Lev – 1.1.3
CMS2CMS Connector: by CMS2CMS – 3.7.0
Cookie Notice & Compliance for GDPR / CCPA: by Hu-manity.co – 2.1.0
XStore Core: by 8theme – 4.0.1
GazChap's WooCommerce Auto Category Product Thumbnails: by Gareth 'GazChap' Griffiths – 1.3.1
WPBakery Page Builder: by Michael M - WPBakery.com – 6.7.0
MC4WP: Mailchimp for WordPress: by ibericode – 4.8.6
Massive Addons for WPBakery Page Builder: by MassivePixelCreation – 2.4.6.1
WooCommerce Sync for QuickBooks Online - by MyWorks Software: by MyWorks Software – 2.3.1
Quform: by ThemeCatcher – 2.11.2
Slider Revolution: by ThemePunch – 6.1.5
WooCommerce Infinite Scroll and Ajax Pagination: by SB Themes – 1.1
User Role Editor: by Vladimir Garagulya – 4.60.1
WooCommerce Admin: by WooCommerce – 2.4.4
WooCommerce Advanced Bulk Edit: by George Iron – 4.4.1
WooCommerce Advanced Shipping: by Jeroen Sormani – 1.0.14
Call for Price for WooCommerce: by Tyche Softwares – 3.3.0
WooCommerce Print Products: by weLaunch – 1.6.1
WooCommerce Product Documents: by SkyVerge – 1.11.3
WooCommerce: by Automattic – 5.1.1 (update to version 5.5.1 is available)
Yoast SEO: by Team Yoast – 14.9
WP All Import Pro: by Soflyy – 4.5.8
WP Downgrade | Specific Core Version: by Reisetiger – 1.2.2
WP All Import - WooCommerce Add-On Pro: by Soflyy – 3.2.5
GMAPS for WPBakery Page Builder: by WWP – 1.6
Custom Product Tabs for WooCommerce: by YIKES
Inc. – 1.7.7

YITH WooCommerce Dynamic Pricing and Discounts Premium: by YITH – 1.5.7
YITH WooCommerce Wishlist: by YITH – 3.0.23

### Inactive Plugins (1) ###

WooCommerce Stripe Gateway: by WooCommerce – 4.5.2

### Must Use Plugins (1) ###

StackCache: by Stack CP –

### Settings ###

API Enabled: –
Force SSL: –
Currency: GBP (£)
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: #8 - /shop/
Basket: #5 - /cart/
Checkout: #9 - /checkout/
My account: #10 - /my-account/
Terms and conditions: #9980 - /terms-and-conditions/

### Theme ###

Name: Spectra Theme
Version: 1.0
Author URL: http://8theme.com
Child Theme: ✔
Parent Theme Name: XStore
Parent Theme Version: 8.0.1
Parent Theme Author URL: http://www.8theme.com
WooCommerce Support: ✔

### Templates ###

Overrides: xstore/woocommerce/archive-product.php
xstore/woocommerce/cart/cart-empty.php
xstore/woocommerce/cart/cart-item-data.php
xstore/woocommerce/cart/cart-shipping.php
xstore/woocommerce/cart/cart.php
xstore/woocommerce/cart/cross-sells.php
xstore/woocommerce/cart/mini-cart.php
xstore/woocommerce/checkout/form-billing.php
xstore/woocommerce/checkout/form-checkout.php
xstore/woocommerce/checkout/form-shipping.php
xstore/woocommerce/checkout/thankyou.php
xstore/woocommerce/content-product-cat.php
xstore/woocommerce/content-product.php
xstore/woocommerce/content-single-product.php
xstore/woocommerce/content-widget-product.php
xstore/woocommerce/content-widget-reviews.php
xstore/woocommerce/global/breadcrumb.php
xstore/woocommerce/global/form-login.php
xstore/woocommerce/global/wrapper-end.php
xstore/woocommerce/global/wrapper-start.php
xstore/woocommerce/loop/loop-end.php
xstore/woocommerce/loop/loop-start.php
xstore/woocommerce/loop/no-products-found.php
xstore/woocommerce/loop/result-count.php
xstore/woocommerce/myaccount/dashboard.php
xstore/woocommerce/myaccount/form-login.php
xstore/woocommerce/myaccount/navigation.php
xstore/woocommerce/single-product/add-to-cart/simple.php
xstore/woocommerce/single-product/meta.php
xstore/woocommerce/single-product/product-image.php
xstore/woocommerce/single-product/related.php
xstore/woocommerce/single-product/tabs/tabs.php
xstore/woocommerce/single-product/title.php
xstore/woocommerce/single-product/up-sells.php
xstore/woocommerce/single-product.php

### Action Scheduler ###

Complete: 90
Oldest: 2021-06-23 08:46:55 +0100
Newest: 2021-07-23 10:07:36 +0100

Pending: 1
Oldest: 2021-07-23 11:07:26 +0100
Newest: 2021-07-23 11:07:26 +0100

### Status report information ###

Generated at: 2021-07-23 10:08:09 +01:00
    3 Sons Development

    (@3sonsdevelopment)

    4 years, 10 months ago

    Hey @spectrad,

    Thanks for getting back to us. There are different ways these PDF files could be handled. If I was building this, I would probably set up a “custom field” to hold the download file URL(s). Then in the theme have a button that appears automatically that links to these files when they exist for a product.

    Since this was set up by a developer I would reach out to them and see if they can set this up for you. Since they created the code, they’ll be in the best position to know how to add this to the site.

    Cheers

    MayKato

    (@maykato)

    4 years, 10 months ago

    Hi @spectrad

    We’ve not heard back from you in a while, so I’m marking this thread as resolved. If you have further questions, please feel free to open a new topic.

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘CSV Import Attaching Datasheets’ is closed to new replies.

Tags