Forums / General Questions / Importing XML Feeds Advice Needed

Importing XML Feeds Advice Needed

Locked

Views: 1,188

Results 1 to 11 of 11
This thread is locked. New replies are disabled.
6 Jun 2008, 7:30 PM
#1
stevecollins avatar

stevecollins

New Zenner

Join Date:
Aug 2005
Location:
Southampton
Posts:
80
Plugin Contributions:
0

Importing XML Feeds Advice Needed

Hi,

One of my suppliers is offer a live product feed using XML. Is this something that can be easily implemnented with the latest version of zencart?

As they are selling approximately 35000 products this would be very useful to me as I would not need to manually check how much stock they carry for any item as it should automatically update from their database.

Any advice, warnings or any other info would be very useful.

many thanks in advance for any replies.

6 Jun 2008, 10:06 PM
#2
enigmabomb avatar

enigmabomb

New Zenner

Join Date:
Jan 2008
Posts:
49
Plugin Contributions:
0

Re: Importing XML Feeds Advice Needed

Yes, I am doing it every day.

Use php 5 and lookup SimpleXML. From there, you can parse the incoming information and add the product, products description, and manufacturer info.

Josh

6 Jun 2008, 11:46 PM
#3
stevecollins avatar

stevecollins

New Zenner

Join Date:
Aug 2005
Location:
Southampton
Posts:
80
Plugin Contributions:
0

Re: Importing XML Feeds Advice Needed

Thank you very much for your assistance. Your help is very appreciated. One other thing though, does this allow for products to be uploaded manually that are not from my supplier. For example if I have multiple suppliers that I hold stock from as well as this supplier who I have dropship the items?

6 Jun 2008, 11:55 PM
#4
enigmabomb avatar

enigmabomb

New Zenner

Join Date:
Jan 2008
Posts:
49
Plugin Contributions:
0

Re: Importing XML Feeds Advice Needed

Just put it in the same format. CSV owns me!

6 Jun 2008, 11:57 PM
#5
stevecollins avatar

stevecollins

New Zenner

Join Date:
Aug 2005
Location:
Southampton
Posts:
80
Plugin Contributions:
0

Re: Importing XML Feeds Advice Needed

Thanks very much Josh. I take it I have to download this from somewhere. Is it a dificult task to install and get up and running?

7 Jun 2008, 1:24 AM
#6
enigmabomb avatar

enigmabomb

New Zenner

Join Date:
Jan 2008
Posts:
49
Plugin Contributions:
0

Re: Importing XML Feeds Advice Needed

How well do you know PHP and MySQL? The intensive part here is making sure:

No Duplicates
Update changed ones
Add New Ones
Delete Old Ones

Youll have to write the majority of this from scratch.

zen_remove_product will help.

As for adding, check out easy populate for some example code.

7 Jun 2008, 1:32 AM
#7
enigmabomb avatar

enigmabomb

New Zenner

Join Date:
Jan 2008
Posts:
49
Plugin Contributions:
0

Re: Importing XML Feeds Advice Needed

Also, feel free to PM me any questions you might have. There are some intricacies Ive had to deal with. Namely, to use the zen functions, you have to recreate the db object in php5.2

if (!is_object($db)) {
 //PHP 5.2.0 bug workaround ... 
	$db = new queryFactory();
	$db->connect("localhost", "root", "root", "bernie_chcart", USE_PCONNECT, false);
}
//zen_remove_product($idarray['products_id']);
7 Jun 2008, 2:16 AM
#8
stevecollins avatar

stevecollins

New Zenner

Join Date:
Aug 2005
Location:
Southampton
Posts:
80
Plugin Contributions:
0

Re: Importing XML Feeds Advice Needed

I am not that familiar with PHP in the sense that I could not program a page without major research first. MySQL is something that I know enough to get by on.

Most of my ability is more to do with changing around what is already there rather than starting from scratch.

I appreciate the offer of PMing you. I will do a little research first so that I ca familiarise myself with some of this stuff. That way I do not waste your time asking silly questions. Many thanks for all of your answers. I will be in contact soon via PM.

9 Jun 2008, 6:56 PM
#9
mate2007 avatar

mate2007

New Zenner

Join Date:
May 2007
Posts:
35
Plugin Contributions:
0

Re: Importing XML Feeds Advice Needed

Hi Steve

Can you give me a link to the xml feed you want to import, its possable i might be able to help you out.

Drop me a pm if you like

Regards

Mate2007

17 Jun 2008, 11:54 PM
#10
oavs avatar

oavs

Totally Zenned

Join Date:
Jan 2006
Location:
Downunder - QLD - Gold Coast
Posts:
921
Plugin Contributions:
0

Re: Importing XML Feeds Advice Needed

Hi

I have the similar question to using datafeeds. Can anyone help where I should be starting please ?

My drop ship supplier provides daily inventory feed in CSV format.

they provide me with links such as following but I have no idea how to use the CVS file with zencart.
https://www.dropship-wholesaler.com/dailycartfiles/products.csv
https://www.dropship-wholesaler.com/dailycartfiles/options.csv

Please help.

Downunder QLD

29 Jun 2009, 3:11 AM
#11
bigduckspoker avatar

bigduckspoker

New Zenner

Join Date:
Jan 2009
Location:
O'Fallon, Illinois
Posts:
5
Plugin Contributions:
0

Re: Importing XML Feeds Advice Needed

I HAVE A GREAT FIX TO THIS AND IT UPDATES AUTOMATICALLY!
I found a guy who scripts and he did a great job for me! My site updates products, inventory, and pictures... ALL AUTOMATICALLY! I'm using an .XML feed for my inventory updates... AUTOMATICALLY! I only have to load ONE .csv file to a folder when my supplier updates their products... I don't have to use Easy Populate Advanced... the script DOES IT FOR ME! Loading pictures? IT DOES IT FOR ME! We're talking in seconds! My picture all show up and my inventory stays current!

You will have to pay a little money, but his theory is all the time you spend fudging with your cart, is the time you could be managing sales!

Email me for the hook up!