AdWords
1.9K members online now
1.9K 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,,,,