Zen Cart Logo
Forums / All Other Contributions/Addons / easy populate all my prices show 0.00

easy populate all my prices show 0.00

Locked

Views: 4,930

Results 1 to 20 of 32
This thread is locked. New replies are disabled.
10 Jan 2008, 10:40 PM
#1
dichroic avatar

dichroic

New Zenner

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

easy populate all my prices show 0.00

Hey,
I just downloaded EAsy Populate (I'm trying the free version first) At any rate, I downloaded the sample contents to see how things should be written. I then made my headings the same and entered all my data in excel and Saved as Txt I uploaded and was pleased to see that the products were in my store. How ever when I click on an item look at it there is no price and when placed in my cart it says it's $0.00. This is a problem seeing as I can't give my products away no matter how much I'd like to . Any idea what may be the cause?
Here are my product headings if that helps. They do show up as 1 lnie on my screen.
v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_products_price v_products_weight v_date_avail v_date_added v_products_quantity v_manufacturers_name v_categories_name_1 v_categories_name_2 v_tax_class_title v_status EOREOR

Thanx in advance

10 Jan 2008, 10:49 PM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: easy populate all my prices show 0.00

Is it only your easypopulate products that are affected?
Have you entered any products normally? Do they show correctly?

Possible related FAQ: https://www.zen-cart.com/tutorials/index.php?article=96

11 Jan 2008, 12:13 AM
#3
dichroic avatar

dichroic

New Zenner

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

Re: easy populate all my prices show 0.00

yes, It seems to be only the easy populate items. the few I entered manually are showing up just fine

11 Jan 2008, 12:26 AM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: easy populate all my prices show 0.00

You're probably missing some master_categories_id settings and maybe it didn't calculate all your prices correctly.
There are two buttons in Admin->Tools->Store Manager to do that: master-categories-id reset, and reset products price sorter.

But, easypopulate normally does both of those steps automatically for you after it loads your products.

11 Jan 2008, 12:31 AM
#5
dichroic avatar

dichroic

New Zenner

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

Re: easy populate all my prices show 0.00

I'll try that thanx.

11 Jan 2008, 12:41 AM
#6
dichroic avatar

dichroic

New Zenner

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

Re: easy populate all my prices show 0.00

I'm befuddled. I tried the resets but, the prices still don't show
maybe I coded something wrong. I also checked all the settings that the tutorial said to check. I just haven't been able to check on another computer. I'll do that next .

11 Jan 2008, 6:03 AM
#7
misty avatar

misty

Inactive

Join Date:
Apr 2004
Location:
UK
Posts:
5,752
Plugin Contributions:
1

Re: easy populate all my prices show 0.00

v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_specials_price v_specials_date_avail v_specials_expires_date v_products_price v_products_weight v_date_avail v_date_added v_products_quantity v_manufacturers_name v_categories_name_1 v_categories_name_2 v_categories_name_3 v_categories_name_4 v_categories_name_5 v_categories_name_6 v_categories_name_7 v_tax_class_title v_status EOREOR

Above my easy populate headers..tried and tested..
they must be uploaded as tab delimited .csv file NOT .txt file
EVERY product must have unique MODEL number.
I use Open Office, can never get Excel to work
HTH

11 Jan 2008, 6:37 AM
#8
dichroic avatar

dichroic

New Zenner

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

Re: easy populate all my prices show 0.00

Thanx Misty
I may try to revamp my spread sheet

Although digging a little deeper into products price manager. When I check individual products its says current price status is preview only. Is there a way to set my products out of preview mode? Preferably in bulk. I have 4,000 products.

Thanx again everyone

11 Jan 2008, 6:45 AM
#9
misty avatar

misty

Inactive

Join Date:
Apr 2004
Location:
UK
Posts:
5,752
Plugin Contributions:
1

Re: easy populate all my prices show 0.00

Have you got your store set as showcase only
i.e. Visitors can view but not purchase?
Also don't upload more than 300/500 products
at any one time when using Easy Populate.

11 Jan 2008, 6:53 AM
#10
dichroic avatar

dichroic

New Zenner

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

Re: easy populate all my prices show 0.00

how do I check to see if it's set to show case and how can I delete my products and onlu upload 300- 500?

11 Jan 2008, 7:09 AM
#11
misty avatar

misty

Inactive

Join Date:
Apr 2004
Location:
UK
Posts:
5,752
Plugin Contributions:
1

Re: easy populate all my prices show 0.00

Store Status...admin/configuration/mystore/store status
Products..delete via admin
Without seeing actual url of your site, difficult to advise
further.

11 Jan 2008, 7:17 AM
#12
dichroic avatar

dichroic

New Zenner

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

Re: easy populate all my prices show 0.00

URL is https://www.jgcutlery.com/store
Be advised it's a work in progress :)

11 Jan 2008, 7:18 AM
#13
dichroic avatar

dichroic

New Zenner

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

Re: easy populate all my prices show 0.00

store status is set to normal store.
I'll try seting it to showcase and back again maybe it will jog something

11 Jan 2008, 7:23 AM
#15
dichroic avatar

dichroic

New Zenner

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

Re: easy populate all my prices show 0.00

I think I will delete everything in the store tomorrow and try uploading using Misty's headers only loading 300-500 items. hopefully that will solve my problems. Thanx for eveyone's help!

I'll post if I fix the problem

11 Jan 2008, 7:24 AM
#16
dichroic avatar

dichroic

New Zenner

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

Re: easy populate all my prices show 0.00

I have 5 Kabars Idid manually that the price shows or did you check a different product?

11 Jan 2008, 7:31 AM
#17
dichroic avatar

dichroic

New Zenner

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

Re: easy populate all my prices show 0.00

If you checked a different product I'll have to look on a different computer again in the morning. I have to reset stocking levels which is why so many things say sold out.

11 Jan 2008, 8:59 PM
#18
dichroic avatar

dichroic

New Zenner

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

Re: easy populate all my prices show 0.00

Ok, I erased my products and started over. I'm getting the same problem and when I go into product price manager and gointo a catagory it says
Preview Only ... Current Price Status ... Preview Only

Any idea how to fix this?

Thanx in advance

11 Jan 2008, 9:33 PM
#19
chadderuski avatar

chadderuski

Totally Zenned

Join Date:
Apr 2006
Location:
Dark Side of the Moon
Posts:
986
Plugin Contributions:
0

Re: easy populate all my prices show 0.00

Don't forget that every line needs EOREOR for EP to work properly.

The best way to use this TOOL is to start with a fresh empty database, use the Backup MySQL plugin to make backups:

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=81

So you can roll back your data bases if something fudges.

Add a couple items normally through the admin with all relavant data, then export these with the:

Download Complete tab-delimited .txt file to edit (Attributes Not Included)

option. This will give your working format. Open Excel and Import Your data, when done editing, save as Tab Delimited File. One quirk I've noticed on mac ... once you save, quit program without re-saving.

-Chaddro

11 Jan 2008, 10:00 PM
#20
dichroic avatar

dichroic

New Zenner

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

Re: easy populate all my prices show 0.00

Thanx I'll try that next