Database driven selling

[hargreaves56]

Evening

I have just spent most of the evening updating prices and images on our website and ebay store and our own spreadsheets. Mind numbing stuff.

What would be good is if I could change my listings on ebay and the website when I just change the spreadsheet. Eg price increase across all products by 2%!

I know eSellerPro and ChannelAdvisor will help me do that. But they are expensive for the number of products we have.

Is there anyway anyone knows about by using raw techniques like mySQL or simple databases. Feeding into Ebay and our website?

 

[sanjiv]

Could probably do something to update your website when you update Ebay. Please PM me if you are interested.

 

[Faevilangel]

It would be possible to create a script that gathers your prices from your ebay store and that will populate your own webstore...

It won't work the other way though (as you don't get access to ebay's database)

 

[hargreaves56]

Its not just prices. Its title, image, spec details and content.

Is there a way to bulk upload to ebay but within your html template code?

 

[sanjiv]

Yes that is possible. Sorry if my first post made it seem like only prices. Please PM me and we can discuss this.

Thanks
Sanj

 

[Faevilangel]

Its not just prices. Its title, image, spec details and content.

Is there a way to bulk upload to ebay but within your html template code?

Yeah it's possible... IMHO I would get someone who has done it before, ask on the ebay forums for recommendations

 

[hargreaves56]

I have found the ebay forums very unhelpful.

 

[brownie]

You need to get familiar with Turbolister, Turbolister will accept importing of CSV files. CSV files can be manipulated in Excel or Openoffice Calc.

Initially you need to keep a record of your products in a spreadsheet, hence it is easy to add 2% onto your sell prices then reupload to Ebay.

It will take a little time to delve into the detail of the correctly formatted CSV file, there's more info at http://pages.ebay.com/turbo_lister/csv.html, if you want to concentrate on running your business and want someone here to setup the initial CSV file then shout.

Once done, it'll make your life a lot simpler, import the CSV to Turbolister, hit a button and all of your products will be entered into Ebay by Turbolister.

 

[hargreaves56]

Thanks Brownie. Can this option really work with my listing design:
http://bit.ly/aZPlGi

 

[sanjiv]

You need to get familiar with Turbolister, Turbolister will accept importing of CSV files. CSV files can be manipulated in Excel or Openoffice Calc.

Initially you need to keep a record of your products in a spreadsheet, hence it is easy to add 2% onto your sell prices then reupload to Ebay.

It will take a little time to delve into the detail of the correctly formatted CSV file, there's more info at http://pages.ebay.com/turbo_lister/csv.html, if you want to concentrate on running your business and want someone here to setup the initial CSV file then shout.

Once done, it'll make your life a lot simpler, import the CSV to Turbolister, hit a button and all of your products will be entered into Ebay by Turbolister.

Do you update the items or delete and import them again?

 

[brownie]

Manipulate the CSV, then Turbolister will update them, no need to delete and re upload

 

[brownie]

Thanks Brownie. Can this option really work with my listing design:
http://bit.ly/aZPlGi

The bit.ly link is not working, can you repost?

 

[hargreaves56]

It should go to:

http://cgi.ebay.co.uk/BB50D-Bambi-S...Compressors&hash=item439e98e98e#ht_1498wt_944

Or search "BB50D Bambi Silent Air Compressor (8 Bar 50 Litre 1 HP)" in ebay UK

 

[FreelanceSoftwareDeveloper]

It can be done, so you update your website then sync with eBay, also automatic listing of items you add to your website.

Here is a demo I created which does half the job. It takes a product from the website and formats it to an eBay listing with all the additional graphics, text etc that you use on eBay.

http://tinyurl.com/374pg2n

This was designed as a front end application for a dropshipping website, each user could customise their Payment/Contact/Delivery terms in their account area. It uses 3 different template designs based on product category.

What I was working on but it's on the back burner at the moment is a similar script which works with the eBay APIs for auto listing and updates to price and stock levels. I have an eCommerce store with 1300 products and I want a backend that will allow me to filter out various products then list them on eBay. It will use a database to manage active listings, excluded products etc and run as a cron job to update every X hours.

 

[hargreaves56]

Wow barrowmatt, that is great. Very nice application. I would be interested in talking to you a little bit about it.

 

[AdrianW]

If you decide to use TurboLister to update Ebay, then one of the guys on here could write something to make the same CSV update your webpages. This could be done by creating html or by using a database instead. I'm doing this for clients but I'm not the only shop in town (or even the only one in Nottingham)
Adrian
rawsys.com