Zen Cart Logo
Forums / General Questions / inport and export product list, excell

inport and export product list, excell

Locked

Views: 4,651

Results 1 to 13 of 13
This thread is locked. New replies are disabled.
6 Feb 2008, 1:28 PM
#1
kitcorsa avatar

kitcorsa

Totally Zenned

Join Date:
Feb 2007
Posts:
1,724
Plugin Contributions:
0

inport and export product list, excell

think ive asked this before but dont think i got a reply or and answer to the post as i dont know the answer.

is there a mod or a way to export the product database into an excell file so i can edit the information in excell then i can edited prices and information more easly and the upload the new excell and change all the products on my site.

this would help me loads as my suppliers always supply me with a new excell file for all the new products and prices.

6 Feb 2008, 1:47 PM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: inport and export product list, excell

Easy Populate

6 Feb 2008, 2:28 PM
#3
kitcorsa avatar

kitcorsa

Totally Zenned

Join Date:
Feb 2007
Posts:
1,724
Plugin Contributions:
0

Re: inport and export product list, excell

Cheers Kobra

Ill Have A Look At That Patch Now :d

Just Got A New Csv File Fom Supplier

6 Feb 2008, 4:40 PM
#4
kitcorsa avatar

kitcorsa

Totally Zenned

Join Date:
Feb 2007
Posts:
1,724
Plugin Contributions:
0

Re: inport and export product list, excell

there are 2 easy populate mods, can any recogment which one better and less likly to kill my site please.

7 Feb 2008, 9:47 AM
#6
kitcorsa avatar

kitcorsa

Totally Zenned

Join Date:
Feb 2007
Posts:
1,724
Plugin Contributions:
0

Re: inport and export product list, excell

whats modhole??

7 Feb 2008, 1:03 PM
#7
kitcorsa avatar

kitcorsa

Totally Zenned

Join Date:
Feb 2007
Posts:
1,724
Plugin Contributions:
0

Re: inport and export product list, excell

whats the easy populate avanced 3 mod as well?? seem to be a feu that all do a simular thing

7 Feb 2008, 2:07 PM
#8
kitcorsa avatar

kitcorsa

Totally Zenned

Join Date:
Feb 2007
Posts:
1,724
Plugin Contributions:
0

Re: inport and export product list, excell

misty:

http://www.zen-cart.com/archived_contributions/admin-tools/
ep 1.2.5.4. as modhole(dev's website) currently not available

right ive installed this mod as instructed and installed with out a probalem and i have downloaded the text file and opened it in excell which is great.

Quick questions??

  1. if i add new products will these be added to my site then all ill need to do is upload an image to suit the produc??

2)when working in excell do i need to leave the file as is or can i rearrage the lists with out wrecking my site?? ie arrage it a-z in the manufactuer colum so i can find products more easy?? i gather the top row neew to stay top.

8 Feb 2008, 9:45 AM
#9
kitcorsa avatar

kitcorsa

Totally Zenned

Join Date:
Feb 2007
Posts:
1,724
Plugin Contributions:
0

Re: inport and export product list, excell

well been reading the suppoirt thred for 3 hours now and still not got the answer to these questions. can someone please answer and save me a day of my life to update products.

8 Feb 2008, 3:23 PM
#10
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: inport and export product list, excell

  1. if i add new products will these be added to my site then all ill need to do is upload an image to suit the produc??
    Just insure that the end of line is at every added line and yes this is what this mod is for
    2)when working in excell do i need to leave the file as is or can i rearrage the lists with out wrecking my site?? ie arrage it a-z in the manufactuer colum so i can find products more easy?? i gather the top row neew to stay top.
    Not sure but what I would do is determine what the list is currently sorted on then sort as you need and when done re-sort back to original - save - for uploading
8 Feb 2008, 4:19 PM
#11
kitcorsa avatar

kitcorsa

Totally Zenned

Join Date:
Feb 2007
Posts:
1,724
Plugin Contributions:
0

Re: inport and export product list, excell

i looked at this. the list is in product number order, ie the first product i entered first.

there doesn't seem to be a product id number colum. if there was i could just arage it how ever and then arrange it back

8 Feb 2008, 4:59 PM
#12
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: inport and export product list, excell

I do not use easy populate but recall that you must have model # defined as this is what it uses

11 Feb 2008, 1:39 PM
#13
kitcorsa avatar

kitcorsa

Totally Zenned

Join Date:
Feb 2007
Posts:
1,724
Plugin Contributions:
0

Re: inport and export product list, excell

when i open the file in excell there is no product number colum. but the numbers down the side (excell coloum numers) are the product numbers