The information in this thread might be outdated
If the solution did not help, please, check our Help Portal or contact Ecwid Team.
 
 
Thread Tools Display Modes
  #1  
Old 08-24-2011, 02:15 AM
SoBe Couture's Avatar
SoBe Couture is offline
Senior Member
 
Join Date: Apr 2011
Posts: 232
Lightbulb

Inventory and Sales Excel Spreadsheet Workbook V2.0 | Clean Integration with Google Merchant Center | Integration with Sharepoint and or Skydrive


-___-----___----- CXM's Master Inventory and Sales with Google Merchant Center_v2.0.zip Download Excel zip file at the end of this post __----__-----__-

Ok, I am creating a 6 video YouTube tutorial so I am going to be light on the words if you know what I mean. VISIT THIS THREAD FOR THE ORIGINAL SPREADSHEET INFORMATION regarding Version 1.0:
http://www.ecwid.com/forums/showthread.php?t=5914

Version 2.0 does the following:

-- Removes Data Validation so Excel file can be successfully uploaded to Sharepoint or Windows Live Skydrive to open online via Microsoft Web Apps for Excel (I am upset to have to do this but it was the only way)

-- Adds all parameters for the "Stringent Guidelines that Google Merchant Center will enact as of September 22nd 2011 of this year." fields such as id, title, google product category, image link, shipping weight, etc... http://www.google.com/support/mercha...?answer=188494

-- Enables the Final Spreadsheet entitled GoogleMC (for Google Merchant Center) to be saved as a Tab Delimited File / txt so that it will be viable for Google Data Feeds Products Submission. <<< The MOST ACCURATE AVAILABLE

-- Removed dead data and cleaned up monthly sales sheets

-- Provided a 6 + (3 Sharepoint and Windows Live Skydrive Videos) video series on youtube explained exactly how the product spreadsheet works and how you can use it with Google Merchant Center and Sharepoint.

Please Note: The first 3 videos are for the previous version 1.0 and are worth watching to learn how to use the spreadsheet in general.
http://youtu.be/rlP3jrRDfgM <<< Video 1
http://youtu.be/uEPfP7n_Mwg <<< Video 2
http://youtu.be/ISNDkflemHw <<< Video 3
http://youtu.be/0Se8n00f4CE <<< Video 4 <<< Version 2.0 Begins here
http://youtu.be/7uFRcHOPWE8 <<< Video 5 <<< Version 2.0
http://youtu.be/r0SibSyD4sI <<< Video 6 <<< Version 2.0
http://youtu.be/P7oa_8vTE-o <<< Video 7 Bonus Sharepoint Video
http://youtu.be/WSz0XtI1biw <<< Video 8 Bonus Sharepoint End Video


-- Designed it to be future proof for future enhancements and other product submissions such as Ebay, Bing, and more.

With that said, I know that there is other alternatives out there for data submission to google via Ecwid and another entity. In the end I created my version and workaround because of these reasons:

1. I needed something that is the most accurate and holds the best standards for Google Product submissions.

2. I needed something that will work with the inventory and sales workbook that I have already created. I.e. do work as efficiently as possible.

3. I needed something that is future proof and will allow me to integrate with various product submissions besides Google and Ecwid. I.e. Bing will come online shortly.

With that said, I would love for someone to take the work I have done and figure a way to integrate it with Ecwid in some way. An idea I have is this and seems the most rational.

I have made a formal request that Ecwid integrate the ability to take this spreadsheet and use it for Ecwid product submissions as well. This workbook now follows in line with Google Merchant Center product submissions data feed.

Hopefully Ecwid will recognize the usefulness of the spreadsheet and determine if it is worth while to parallel the information into Ecwid as well.

The advantage here is clear. Proposed Workflow as follows:

You get your inventory >>> You input it into the spreadsheet >>> You save a .txt file (or .csv file) >>> You submit to Ecwid >>>> You load your pictures >>> Ecwid returns a .txt file or perhaps xml file >>> You use that file for your Google Merchant Center Data Feed >>> Products go onto Google and Ecwid Seamlessly!!!

As of today, the workflow is as follows:

You can create the .txt from the Excel workbook file and use that .txt submission for your Google data feed. Everything else concerning Ecwid you do on your own separately.

Last edited by SoBe Couture; 08-27-2011 at 09:06 AM.
  #2  
Old 08-25-2011, 03:26 PM
SoBe Couture's Avatar
SoBe Couture SoBe Couture is offline
Senior Member
 
Join Date: Apr 2011
Posts: 232
Default

In case any of you are wondering why I went through the trouble to explain the spreadsheet this way or place "Clean Google Merchant Center Ingegration" in the title. Please read this post carefully. If you are a Google Merchant Center participant you will be affected.

http://base-forum-announcements.blog...e-product.html
  #3  
Old 08-26-2011, 07:01 PM
Matt Malone1's Avatar
Matt Malone1 Matt Malone1 is offline
 
Join Date: Jul 2011
Posts: 9
Default

The GoogleMC spreadsheet is broken. The data from the Master Inventory tab loads into the wrong columns...
  #4  
Old 08-27-2011, 09:05 AM
SoBe Couture's Avatar
SoBe Couture SoBe Couture is offline
Senior Member
 
Join Date: Apr 2011
Posts: 232
Default

Quote:
Originally Posted by Matt Malone1 View Post
The GoogleMC spreadsheet is broken. The data from the Master Inventory tab loads into the wrong columns...
You are correct. I have fixed the error and have since reposted the spreadsheet. If you download again everything should be fine.

Let me know how it goes and if you have any more questions. Also, be careful when copying cell information from top to cells below. If it is a number Excel will incremental increase the value by 1. This can cause an error especially with group ids ids and links ending with numbers.

That error occurred in the spreadsheet and for me as well so just be careful.

Last edited by SoBe Couture; 08-27-2011 at 09:08 AM.
  #5  
Old 09-07-2011, 08:31 PM
qballizhere's Avatar
qballizhere qballizhere is offline
 
Join Date: May 2011
Posts: 7
Default

I wanted to say thank you for putting the work into the spreadsheet. I love it its great. I don't know excel that well and the videos made it simple. I would like to know how to add a column for UPC codes. I was looking at adding it to shop savvy and it is required for them.
  #6  
Old 09-07-2011, 08:52 PM
SoBe Couture's Avatar
SoBe Couture SoBe Couture is offline
Senior Member
 
Join Date: Apr 2011
Posts: 232
Default

Hey Qball,

Thanks for using it.

I wanted to ask a couple background questions regarding your request for UPC codes.

When you add the column for UPC do you want it both on the master inventory sheet and the GooglMC .txt sheet?

If you do then I would suggest you create a new sheet called ShopSavvy beside the GMC and copy everything from the GMC sheet on over.

For both the Master Inventory and the new ShopSavvy Sheet. add the column UPC to the Very end of the sheets so not to mess up any formula's.

On the Master Inventory you can color it something else so you know it is an added field for Shop Savvy.

On the new ShopSavvy sheet at the very end copy a Vlookup forumla, hit enter (please hit enter or you will mess up your sheet) and then paste it into the new UPC column and change the number from 26 or whatever Vlookup you took to the new column number that is on the Master Inventory sheet.

If the last part is confusing - what I mean is this. Vlookup counts by columns. So for example if your column is in letter Z than that is column number 26 and that is the number you should use. It won't be 26 it will be higher because you are using a column at the end of the inventory sheet. So just count past Z and add 26 and that will be your column number.

It will pull in the information from the new column into your new Shop Savvy sheet.

Proceed the same.

Let me know if that helps.
  #7  
Old 10-11-2011, 06:05 PM
Out of This World's Avatar
Out of This World Out of This World is offline
 
Join Date: Mar 2010
Posts: 126
Default

Quick question or two:

1) I use flat-rate shipping; is Google's Shipping Weight value required to be ACTUAL product weight, or can I use "1" for everything (like it's set up in Ecwid)?

2) For things that don't have size/color/gender do they just remain blank or is a 0 value needed?

3) Is "Brand" the same as Manufacturer? We have various items from electronics to toys and games. I'm assuming Brand is "Canon" for cameras and similarly "ThinkFun" for toys, etc.? (Not to be confused with Distributor?)
  #8  
Old 10-11-2011, 06:32 PM
qballizhere's Avatar
qballizhere qballizhere is offline
 
Join Date: May 2011
Posts: 7
Default

For things that do not have a color, gender ect just leave blank. The product category will let them know it is not apparel.
  #9  
Old 01-15-2012, 10:41 PM
SoBe Couture's Avatar
SoBe Couture SoBe Couture is offline
Senior Member
 
Join Date: Apr 2011
Posts: 232
Default

Quote:
Originally Posted by Discount Binoculars View Post
Quick question or two:

1) I use flat-rate shipping; is Google's Shipping Weight value required to be ACTUAL product weight, or can I use "1" for everything (like it's set up in Ecwid)?

2) For things that don't have size/color/gender do they just remain blank or is a 0 value needed?

3) Is "Brand" the same as Manufacturer? We have various items from electronics to toys and games. I'm assuming Brand is "Canon" for cameras and similarly "ThinkFun" for toys, etc.? (Not to be confused with Distributor?)
Yes, make sure to keep it blank because that is a 0 value will not show up as an error or a mistake to GSM
  #10  
Old 02-08-2012, 11:26 AM
celeste kinya's Avatar
celeste kinya celeste kinya is offline
Junior Member
 
Join Date: Feb 2012
Posts: 1
Exclamation broken Panels

Hey, i managed to download your inventory and sales excel spreadsheet. And its really great however it has broken panels and the data is appearing in the wrong columns. could you kindly repost one without broken panels. thanx
 
The information in this thread might be outdated
If the solution did not help, please, check our Help Portal or contact Ecwid Team.

Tags
excel, inventory, quickbooks, sales, sharepoint

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 02:41 PM.
Powered by vBulletin® Version 3.8.11. Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.