Merry Christmas 2020
Supplier provided two separate URL links to download Data Feed for Product Upload:
I am about to upload/refresh the Product data in our store, and will use the file: CSV Shopify.
My concern is the other file called CSV All. This file contains massive amount of data in a lot of column headers.
What is this file for, and will my Product info be incomplete if this file is used to upload?
Please advise, thank you.
File labeled CSV Shopify
> No Variants - File has same headers as the exported file < |
File labeled CSV All
> Has Variants and multiple cats and images columns < |
| Handle |
sku |
| Title |
name |
| Body (HTML) |
description |
| Vendor |
updated_at |
| Type |
upc |
| Collection |
msrp |
| Tags |
date_released |
| Published |
qty_avail |
| Option1 Name |
gross_weight |
| Option1 Value |
size_length |
| Option2 Name |
size_width |
| Option2 Value |
size_circumference |
| Option3 Name |
wholesale_price |
| Option3 Value |
MAP |
| Variant SKU |
special_features |
| Variant Grams |
how_to_use |
| Variant Inventory Tracker |
how_to_clean |
| Variant Inventory Qty |
purpose |
| Variant Inventory Policy |
price |
| Variant Fulfillment Service |
manufacturer |
| Variant Price |
cat.cat_0 |
| Variant Compare At Price |
cat.cat_1 |
| Variant Requires Shipping |
cat.cat_2 |
| Variant Taxable |
cat.cat_3 |
| Variant Barcode |
images.0.filename |
| Image Src |
images.0.width |
| Image Position |
images.0.height |
| Image Alt Text |
images.0.filesize |
| Gift Card |
images.0.type |
| SEO Title |
images.0.view |
| SEO Description |
images.0.orientation |
| Google Shopping / Google Product Category |
video |
| Google Shopping / Gender |
Color |
| Google Shopping / Age Group |
Power |
| Google Shopping / MPN |
Included |
| Google Shopping / AdWords Grouping |
Feature |
| Google Shopping / AdWords Labels |
Flavor |
| Google Shopping / Condition |
Display |
| Google Shopping / Custom Product |
Material |
| Google Shopping / Custom Label 0 |
Packaging |
| Google Shopping / Custom Label 1 |
Item Language |
| Google Shopping / Custom Label 2 |
Country of Origin |
| Google Shopping / Custom Label 3 |
Prop 65 |
| Google Shopping / Custom Label 4 |
Bulk |
| Variant Image |
|
| Variant Weight Unit |
|
| Variant Tax Code |
|
| Cost per item |
|
Both files are not valid Google Merchant Center Feeds, some attributes are but it does not make any sense.
If you want to know what attributes are accepted: https://support.google.com/merchants/answer/7052112?hl=en
Appreciate the response, but there seems to be an issue regarding this, I will try to explain-
The link you provided is the first time I have seen this information. The problem is when referencing //help.shopify.com/en/manual/products/import-export/using-csv, it sends me to this page:
Get a sample CSV file
You can download and view a sample product CSV file to use as a template.
-
The sample file contains an example product and a couple of variants. Your import file likely contains many more products and variants. If you use the sample file to create your own import file, then make sure that you remove all the example products.
-
The sample file includes the Variant Inventory Qty column, which is only used for stores that have a single location. If you use multiple locations and you want to import or export inventory quantities, then use the inventory CSV file.
The online help manual seems to provide only the basics of any topic, but that was the only reference provided. None of the information from the link you provided matches up with this template file, or the Header format descriptions further down the page. So at this point, I am not certain with any confidence I have the proper Product data uploaded, and the software does not allow me to view the base tables.
Also, does the software allow adding custom fields (headers) to the product description? There exists additional, and relevant information for each product in the store.
The shopify manual expert system is not designed for submitting to Google Merchant Center.
You need to use an app or management tool to do this. Your approach will leave your head-scratching for months.
Simply search for Shopify app for Google Shopping, you will find what you need. You can get yourself up and running in less then an hour.
My apologies, I’m not sure where you got Google Merchant Center, as I am not anywhere near ready to deal with that.
Is it something I need to be aware of?
My apologies, I got confused with your question. I assumed you were talking about uploading to Google. Ignore my replies.
No worries, it’s understood.
My issue is I cannot be certain I am uploading the proper HEADER information for our products.
I discovered there are numerous products that are not assigned to a category, or type, or tag, so there is no way I can show them in the store.
Today I exported an ALL PRODUCTS CSV and found over 300 items missing TYPE and TAG data. The imported CSV did not indicate missing data.
How can I resolve this? The golden rule is “Good Stuff In, Good Stuff Out!”
|
|
|
|
|
PRODUCT HAS DATA
|
|
|
Handle
|
Title
|
Body (HTML)
|
Vendor
|
Type
|
Tags
|
Published
|
|
hemp-seed-3-in-1-massage-candle-hot-rod-6-oz-eb-hsc034
|
3-in-1 Massage Candle - Hot Rod - 6 Oz.
|
The Earthly Body Fragrant Natural Soy-Oil Candle
|
Earthly Body
|
Candles
|
Bath & Body, Bath & Body | Candles,
|
TRUE
|
|
|
|
|
|
|
|
|
|
|
|
|
|
PRODUCT MISSING DATA
|
|
|
Handle
|
Title
|
Body (HTML)
|
Vendor
|
Type
|
Tags
|
Published
|
|
player-extra-heavy-duty-aa-batteries-2-pack-sp1-2pack
|
Player Extra Heavy Duty AA Batteries - 2 Pack
|
AA batteries.
|
Vinnic & Player Batteries
|
|
|
TRUE
|