Help Installing Addons

[janderson78]

Hello,

My name is Jason and I am new to Zen. I have got my site up and going www.sworkz-usa.com

I have a few test products up and have had no issues loading anything. But with my business I am a distributor and need to have wholesale priceing.

I have downloaded the Addon and read everything I can find. I understand the drag and drop to the same folder in you public site via FTB

But I am having an issue learning how to do the following.
ALTER TABLE `customers` ADD `customers_whole` VARCHAR( 4 ) DEFAULT '0' NOT NULL;

ALTER TABLE `products` ADD `products_price_w` DECIMAL( 15, 4 ) DEFAULT '0' AFTER `products_price`;

ALTER TABLE `products_attributes` ADD `options_values_price_w` DECIMAL( 15, 4 ) DEFAULT '0' AFTER `options_values_price`;


So if you could please point me in the right direction it would be awesome!

[schoolboy]

There are (fundamentally) TWO parts to the "engine" of your site:

1. Code files and other files (which will include images).

2. A Database, which is the repository for much of the content of the site.

Many add-ons (though most certainly not all), will need to ADD components to the database, in addition to adding to (or altering) the files.

In your case, you are showing some SQL code, suggesting that the add-on you are trying to load, is one of those that needs DATABASE modifications, as well as new (or edited) FILES sent to the server.

You will "run" these SQL patches through ADMIN-CONSOLE >>> TOOLS >>> INSTALL SQL PATCHES.

After running them, the necessary modifications will have been made to your database in order for that module to function correctly.

BEWARE! It is good practise to ALWAYS BACKUP your database before you run SQL patches.

Databases are usually backed up using tools in your webhost C-Panel interface.

[janderson78]

Thanks again so very much for such a great answer. I will look in the admin section when I return home and see if I can make it work!

[janderson78]

Ok so I have now tried it 4 times with mo luck...

Anyone know someone who is good with zen that I can pay a small fe to and get the addons I need up and running?

I need MAP, Retail and wholesale prices and be able to identify which customers see what.

I also need it to print packing and shipping labels/lists

I need it to do inventory orders or be able to print excell sheets specific to each manufacture.


Let me know of anything you guys can think of to help.

Jason