Jump to content
Sign in to follow this  
blucollarguy

EZ_Price_Updater updated for MS2 2.2

Recommended Posts

I forgot to include the short cut to "EZ_Price_Updater" in the admin.

Here it is:

And in catalog/admin/includes/column_left.php add wherever you want the shortcut:

 

require(DIR_WS_BOXES . 'pqu.php');

 

I will update the instructions.


Happy Coding!

Craig Garrison Sr

Anything worth having, is worth working for.

Multi Vendor Shipping V1.1 Demo Catalog

3 Vendors, each category, "buy" a product from each category to see how MVS works during checkout.

Multi Vendor Shipping V1.1 Demo Admin

login: webmaster@blucollarsales.com

pass: mvs_demo

MVS Thread:

Multi-Vendor Shipping

My contribs:

Download Multi Vendor Shipping V1.1

Vendor Email

Vendor Info in easypopulate

EZ Price Updater

And more to come!

Share this post


Link to post
Share on other sites

We're running into the following error:

 

1052 - Column: 'products_name' in order clause is ambiguous

SELECT * FROM products_description,products WHERE products_description.products_id=products.products_id and products_description.language_id = '1' ORDER BY products_name LIMIT 35

 

Please advise!

 

Thx


Carpe Carp: Seize the Fish.

Share this post


Link to post
Share on other sites

I am looking into your error Codi. I have so far, not been able to mimic it yet but I will get back to you. Craig


Happy Coding!

Craig Garrison Sr

Anything worth having, is worth working for.

Multi Vendor Shipping V1.1 Demo Catalog

3 Vendors, each category, "buy" a product from each category to see how MVS works during checkout.

Multi Vendor Shipping V1.1 Demo Admin

login: webmaster@blucollarsales.com

pass: mvs_demo

MVS Thread:

Multi-Vendor Shipping

My contribs:

Download Multi Vendor Shipping V1.1

Vendor Email

Vendor Info in easypopulate

EZ Price Updater

And more to come!

Share this post


Link to post
Share on other sites

Ok Codi, this is what I think. This is a strange error! The reason it is so strange is that the field "products_name" only exists in the TABLE PRODUCTS DESCRIPTION. That is critical for this error since the code uses the wildcard "*" to get all info, and the only common field is the one that links the 2 tables is "products_id", the only wat for the code to be "ambiguous" is for there to be common fields that are not "defined" properly. Have you added another mod that for some reason may have added the field "products_name" to the table "PRODUCTS"? If so, we will need to make several adjustments to the code to accomodate. I will continue to inestigate this, but I am a bit perplexed. Let me know if you have the additional field and I can help you with the code to fix it. It would need to be something like this:

 

$result = tep_db_query("SELECT * FROM " . TABLE_PRODUCTS_DESCRIPTION . " pd," . TABLE_PRODUCTS . " p WHERE " . TABLE_PRODUCTS_DESCRIPTION . "pd.products_id=" . TABLE_PRODUCTS . "p.products_id and " . TABLE_PRODUCTS_DESCRIPTION . "pd.language_id = '" . $languages_id . "' ORDER BY $sort LIMIT $pageSize");

Then we would need to change the $sort definition as well. This would need to be done in many different places throughout the code. Or you could change the field name in table PRODUCTS, this could of course messup something else, but it would be another option. So let me know. Craig.


Happy Coding!

Craig Garrison Sr

Anything worth having, is worth working for.

Multi Vendor Shipping V1.1 Demo Catalog

3 Vendors, each category, "buy" a product from each category to see how MVS works during checkout.

Multi Vendor Shipping V1.1 Demo Admin

login: webmaster@blucollarsales.com

pass: mvs_demo

MVS Thread:

Multi-Vendor Shipping

My contribs:

Download Multi Vendor Shipping V1.1

Vendor Email

Vendor Info in easypopulate

EZ Price Updater

And more to come!

Share this post


Link to post
Share on other sites

Great, hope it gets done what you need. I will take a look at the "stock_updater" myself and see if it will work for me as well. Craig


Happy Coding!

Craig Garrison Sr

Anything worth having, is worth working for.

Multi Vendor Shipping V1.1 Demo Catalog

3 Vendors, each category, "buy" a product from each category to see how MVS works during checkout.

Multi Vendor Shipping V1.1 Demo Admin

login: webmaster@blucollarsales.com

pass: mvs_demo

MVS Thread:

Multi-Vendor Shipping

My contribs:

Download Multi Vendor Shipping V1.1

Vendor Email

Vendor Info in easypopulate

EZ Price Updater

And more to come!

Share this post


Link to post
Share on other sites

I hope you can help in EZ_Price_Updater my Visisble Price - List does not have all my products in, is there somewhere that I need to refresh or update this list?


Pixy

One day at a time - we all have to learn

Share this post


Link to post
Share on other sites
I hope you can help in EZ_Price_Updater my Visisble Price - List does not have all my products in, is there somewhere that I need to refresh or update this list?

Pixy, the list should be populated automatically. It does filter by "status", so you may not be seeing all products listed if some are "not available". Also, recently, I have realised that the link for "All price Update" is not funcitoning properly any more on my server and I have received several notes that indicate this may be due to php or mysql updates.

Another contribution you may look into that is up to date:

Price Updater

Good luck, Craig :)


Happy Coding!

Craig Garrison Sr

Anything worth having, is worth working for.

Multi Vendor Shipping V1.1 Demo Catalog

3 Vendors, each category, "buy" a product from each category to see how MVS works during checkout.

Multi Vendor Shipping V1.1 Demo Admin

login: webmaster@blucollarsales.com

pass: mvs_demo

MVS Thread:

Multi-Vendor Shipping

My contribs:

Download Multi Vendor Shipping V1.1

Vendor Email

Vendor Info in easypopulate

EZ Price Updater

And more to come!

Share this post


Link to post
Share on other sites

Is there any to make this contribution update prices by price range? For example, I want to have products that cost a certain dollar amount to be marked up by a certain percentage. See the chart below for more details:

 

 

Price -----------------> Mark Up

$1-$50 ----------------> 30%

$51-$100 -------------> 20%

$101-$200 ------------> 15%

$201-$300 ------------> 10%

$301+ ------------------> 5%

Edited by ElNino

Share this post


Link to post
Share on other sites

I'm looking for a contribution that will allow me to update all products individually, but on the same page... if that makes sense. This contribution sounded ideal, and indeed looks ideal - however when I look at the price list the price fields are marked as READONLY - does anyone know why that would be?

 

This is a nice little mod to quickly be able to update every price in your catalog. It will list all products prices. You can update one at a time from the list, or you can increase or decrease the entire catalog a percentage you set. Not bad.

 

Thanks.

Share this post


Link to post
Share on other sites

i installed the EZ_Price_Updater. I works, but i get only the product prices without the tax, i correctly set in the admin menu. the price with tax is shown in the shop an in admin.

 

I need to change the price WITH tax.

 

Can anyone help me???

Share this post


Link to post
Share on other sites

Instead of the product ID, I want to see the product model number and want to sort on this as well.

 

Is there a way to achieve that outcome in this handy program?

 

My php knowledge is unsufficient, please help


Grtz

 

HanZ

 

 

 

-----------

Life is simple, only people make it complicated...

Louis Couperus, Dutch writer (1863-1923)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×