AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Ads
4.6K members online now
4.6K members online now
For questions related to Google Shopping and Merchant Center. Learn to optimize your Shopping ads
Guide Me
star_border
Reply

Need to delete individual google sheets and consolidate to one

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

So I have 10 different sheets I need to consolidate to 1 sheet as it will make pruning easier. If I delete all 10 sheets, how fast will it be removed and I can fetch the one consolidated sheet?

I don't google to get confused and having items being disapproved stating there is duplicate etc.

But then again, I don't want to utilize too much time on this .

Is it ok I delete all 10 immediately and then fetch the consolidated one, like immediately, hour, day? etc??

2 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by MosheTLV (Top Contributor)
June

Need to delete individual google sheets and consolidate to one

[ Edited ]
Top Contributor
# 3
Top Contributor

all data flows into the same linked ad-account,

regardless of how the data is submitted or how

many sheets (feeds) are registered.

 

as to consolidation into one sheet --

 

id values are critical.

(a) consolidate all data into one sheet, keeping all existing id values --

be certain the data is identical in the one sheet, as existed in the many.

(b) submit the new consolidated sheet and carefully
inspect the results, within the products-tab, by
clicking on item titles.

(c) then, after the submitted data has been verified,
delete all the other existing registered data-feeds --
if needed, simply re-submit the one consolidated feed.

if id values are different, then serious policy issues may result --
in that case, submitting entirely empty feeds, with only the first-line
header, and waiting until all items are deleted from the products-tab,
before proceeding with the one consolidated-feed, is critical.

as an aside, using only one, single, primary-feed
for all physical inventory, is a best-practice and
highly recommend -- the one primary-feed can

handle about 100,000 inventory items.

also, once an id value has been assigned to a physical inventory item,
that id value should never, ever change -- id consistency, for all
physical inventory, across all time, regardless of how inventory data
is submitted, is also a best-practice and also highly recommended.

id values are best considered as the merchant's physical-inventory-sku --
that never changes -- rather than tied to any feed submit-method, or any
registered-feed, or any spreadsheet.

google tracks all data based on id -- sku.

 

View solution in original post

Need to delete individual google sheets and consolidate to one

[ Edited ]
Top Contributor
# 2
Top Contributor

1 sheet with all products or 10 sheets with the same total and the same products is identical. So nothing changes.

 

Google sees 1 data feed spreadsheet, which means it only views the product data, regardless of how many sheets it is on.

 

Hope it helps.

Twitter | Linkedin | Community Profile | Shopping Feed Tips From FeedArmy
Did you find any helpful responses or answers to your query? If yes, please click on ‘Accept As Solution’
Marked as Best Answer.
Solution
Accepted by MosheTLV (Top Contributor)
June

Need to delete individual google sheets and consolidate to one

[ Edited ]
Top Contributor
# 3
Top Contributor

all data flows into the same linked ad-account,

regardless of how the data is submitted or how

many sheets (feeds) are registered.

 

as to consolidation into one sheet --

 

id values are critical.

(a) consolidate all data into one sheet, keeping all existing id values --

be certain the data is identical in the one sheet, as existed in the many.

(b) submit the new consolidated sheet and carefully
inspect the results, within the products-tab, by
clicking on item titles.

(c) then, after the submitted data has been verified,
delete all the other existing registered data-feeds --
if needed, simply re-submit the one consolidated feed.

if id values are different, then serious policy issues may result --
in that case, submitting entirely empty feeds, with only the first-line
header, and waiting until all items are deleted from the products-tab,
before proceeding with the one consolidated-feed, is critical.

as an aside, using only one, single, primary-feed
for all physical inventory, is a best-practice and
highly recommend -- the one primary-feed can

handle about 100,000 inventory items.

also, once an id value has been assigned to a physical inventory item,
that id value should never, ever change -- id consistency, for all
physical inventory, across all time, regardless of how inventory data
is submitted, is also a best-practice and also highly recommended.

id values are best considered as the merchant's physical-inventory-sku --
that never changes -- rather than tied to any feed submit-method, or any
registered-feed, or any spreadsheet.

google tracks all data based on id -- sku.