What is the purpose of the 'CSV All' file in product upload?

[RoboCode2000]

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

[EmmanuelFlossie]

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

[RoboCode2000]

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. 

[EmmanuelFlossie]

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.

[RoboCode2000]

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?

[EmmanuelFlossie]

My apologies, I got confused with your question. I assumed you were talking about uploading to Google. Ignore my replies.

[RoboCode2000]

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.	<p>The Earthly Body Fragrant  Natural Soy-Oil Candle</p>	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	<p>AA batteries.</p>	Vinnic & Player Batteries			TRUE