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
2.7K members online now
2.7K members online now
For questions related to Google Shopping and Merchant Center. Learn to optimize your Shopping ads
Guide Me
star_border
Reply

Cant upload spreadsheet

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I used the google template to enter my products but when I upload the file no matter what I do it keeps picking up the google template and not the one I created. Tried deleting the google default template from Google Drive but it wont delete either....Is there a way to use Excel rather than Google spreadsheets?

 

Thanks.

1 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by KathleenG (Community Manager)
September 2015

Re: Cant upload spreadsheet

[ Edited ]
Top Contributor
# 2
Top Contributor


if a feed is registered as a google-spreadsheet then,
the feed cannot be uploaded -- rather, the sheet is
fetched directly via the merchant-center interface or
scheduled to be fetched via the merchant-center.

once the spreadsheet is registered, all the information (rows),
below the second row, must be deleted first -- then,  inventory
data may be entered; the registered data-feed (sheet) cannot
be deleted except via the merchant-center.

all sheet edits should be done within the merchant-center --

if a feed is registered as google-spreadsheet the sheet itself

should simply be ignored within google-drive.

for excel, delete all current feeds first, register a new feed
as .txt tab-delimited and use excel to edit the data -- then,
re-save the sheet as .txt tab-delimited and upload the .txt
tab-delimited file.


that said, generally, never delete the registered data-feed after
being registered -- unless a person at google indicates to do so;
use the same registered data-feed for all updates -- including
all changes, additions, or deletions.

google tracks items by id -- a best practice is to
use an internal sku as the id (e.g. us-abc-123).

note that there is a distinct difference between registering

a feed as .txt tab-delimited and then using a spreadsheet

such as excel or google-sheets to re-save and upload the

.txt file -- vs registering a feed as a google-spreadsheet.

 

posting more exact information such as screen-captures

and exact messages may allow us to diagnose the issue

more specifically.

 

otherwise, the best likely course would be to contact google

so that a person can look directly into the account and feed.

 

see also

https://support.google.com/merchants/#topic=3404780

 

View solution in original post

Marked as Best Answer.
Solution
Accepted by KathleenG (Community Manager)
September 2015

Re: Cant upload spreadsheet

[ Edited ]
Top Contributor
# 2
Top Contributor


if a feed is registered as a google-spreadsheet then,
the feed cannot be uploaded -- rather, the sheet is
fetched directly via the merchant-center interface or
scheduled to be fetched via the merchant-center.

once the spreadsheet is registered, all the information (rows),
below the second row, must be deleted first -- then,  inventory
data may be entered; the registered data-feed (sheet) cannot
be deleted except via the merchant-center.

all sheet edits should be done within the merchant-center --

if a feed is registered as google-spreadsheet the sheet itself

should simply be ignored within google-drive.

for excel, delete all current feeds first, register a new feed
as .txt tab-delimited and use excel to edit the data -- then,
re-save the sheet as .txt tab-delimited and upload the .txt
tab-delimited file.


that said, generally, never delete the registered data-feed after
being registered -- unless a person at google indicates to do so;
use the same registered data-feed for all updates -- including
all changes, additions, or deletions.

google tracks items by id -- a best practice is to
use an internal sku as the id (e.g. us-abc-123).

note that there is a distinct difference between registering

a feed as .txt tab-delimited and then using a spreadsheet

such as excel or google-sheets to re-save and upload the

.txt file -- vs registering a feed as a google-spreadsheet.

 

posting more exact information such as screen-captures

and exact messages may allow us to diagnose the issue

more specifically.

 

otherwise, the best likely course would be to contact google

so that a person can look directly into the account and feed.

 

see also

https://support.google.com/merchants/#topic=3404780

 

Re: Cant upload spreadsheet

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭
Thanks Celebird. Will follow your suggestions,,,,