Zen Cart Logo

Attribute pricing...

Views: 2,079

Results 21 to 24 of 24
6 Mar 2014, 7:42 PM
#21
rainbow_pixie_star avatar

rainbow_pixie_star

Zen Follower

Join Date:
Feb 2012
Posts:
427
Plugin Contributions:
0

Attribute pricing...

With regard to the 'no line 101' I put it into word and then back into txt and it seems to have sorted the line spacing out

6 Mar 2014, 7:50 PM
#22
trinity14 avatar

trinity14

Zen Follower

Join Date:
Jan 2014
Location:
Ontario, Canada
Posts:
252
Plugin Contributions:
3

Re: Attribute pricing...

I did have to go through the module installation slowly to understand what it all meant. :)
I manually entered most of the code but when I was uncertain I used winmerge to compare the files.

I would suggest removing the other wholesale modules because that is where I sense the attribute flaw is hiding.

Once I had installed Twitch Wholesale I had no issue, it seems very thorough.

Good Luck!

6 Mar 2014, 9:11 PM
#23
rainbow_pixie_star avatar

rainbow_pixie_star

Zen Follower

Join Date:
Feb 2012
Posts:
427
Plugin Contributions:
0

Re: Attribute pricing...

Hi,
Already confused, LOLZ!

What do these mean...

** STEP 1 Begin ***

SQL Update - Add the customers_wholesale field to the customers table:
ALTER TABLE customers ADD customers_wholesale VARCHAR(4) NOT NULL DEFAULT '0';

AND

We will now add the third recording position of the wholesale switch - statically in the ORDERS table
SQL update...
ALTER TABLE orders ADD customers_wholesale VARCHAR(4) NOT NULL DEFAULT '0';

Thanks
Amy

6 Mar 2014, 9:14 PM
#24
twitchtoo avatar

twitchtoo

Totally Zenned

Join Date:
Apr 2007
Location:
Ontario, Canada
Posts:
1,733
Plugin Contributions:
14

Re: Attribute pricing...

Log into admin, click Tools -> Install SQL Patches

Copy and paste this into the text box:
ALTER TABLE customers ADD customers_wholesale VARCHAR(4) NOT NULL DEFAULT '0';
ALTER TABLE orders ADD customers_wholesale VARCHAR(4) NOT NULL DEFAULT '0';

Then click send.

That will post a notification at the top of your admin screen that tells you if the SQL lines were processed and the two new columns were added to your database tables.