-
Posts
146 -
Joined
-
Last visited
Posts posted by JoeWoodworker
-
-
I want to have a few "one day only" sales in which a certain percentage of the customer's order total will be given back. In other words, the order total page would simply show a 5% discount for everything in their cart.
I cant seem to find any contributions that would do this. Any suggestions?
Thanks
Joe
-
For anyone else running into this-- Open phpmyadmin, select the configuration table on the left, check the 'set_function' field on the right side and click the 'change' icon over to the left of it (looks like a pencil). Set the 'TYPE' to 'TEXT', blank out the 'Length/Value' box so that it's empty, and leave the 'Null' and 'Default' settings to 'NULL'. All other settings leave blank. Then click SAVE to make this change.
Now go and apply the second SQL query in the documentation-- that one should work fine.
Then from the admin, disable the USPS Methods module, and then re-enable it, and the updated USPS International methods should be available....
I need to do some more testing (it's trial by fire time now)... but my initial testing shows this is working fine....
Thank God someone posted this. The USPS changes have crushed my international customers until I get this fixed.
I'm using PHP 4.4.4. After I follow your instructions for the first SQL change, I tried running the second query. This is the message I get...
Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/header_meta_style.inc.php:27) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/common.lib.php on line 1154
Any suggestions?
-
Jack,
This is a superb contribution. Thanks for updating it.
Do you think this contribution will work on older versions of OSC?
Thanks
Joe
-
I was wondering if it would be possible to have the whos_online contribution display the IP addresses in the order by who has the highest value of contents in their cart.
Any ideas?
-
I just noticed this error when I try to make any changes to the UPS shipping module in the admin page.
Warning: Cannot add header information - headers already sent by (output started at /home/joewood/public_html/catalog/admin/includes/functions/general.php:1279) in /home/joewood/public_html/catalog/admin/includes/functions/general.php on line 18
I suspect it is related to the Mo-Pic contirbution.
I have posted a text file of general.php at the url below.
Thanks to all.
Joe
-
I just installed Big Images (with the help of a new found friend). The only problem is that when you click on the small image in the admin/new product page, the image does not load. It just opens a blank window. In the catalog it works fine.
I checked the coding in popup_image.php in the catalog and admin directories. The coding is identical from one to the other so I guess there is a path related problem.
Any ideas?
-
Database weinerd_osc2 running on localhost
Error
SQL-query :
ALTER TABLE `products` ADD `products_subimage1` VARCHAR( 64 ) AFTER `products_bimage`
MySQL said:
Unknown column 'products_bimage' in 'products'
--------------------
I'm not sure how to add the new column for 'products_bimage'.
Any suggestions for such a fool?
-
I noticed that I was confused about the instructions where they read....
Insert a new column into the products table - products_bimage.
Obviously, I have to do that first. But now I dont quite get how to do that in MYPHPAdmin
Any ideas?
Thanks
Joe
-
I was hoping someone could give me a hand with this little issue regarding the MoPics contribution.
When I go add the new column info in MYPHPAdmin I get this error.
Error
SQL-query :
ALTER TABLE `catalog`.`products` ADD `products_subimage1` VARCHAR( 64 ) AFTER `products_bimage`
MySQL said:
alter command denied to user: 'joewood@localhost' for table 'products'
Any suggestions would be sincerely appreciated.
Thanks
Joe
How to put product on sale if been available for more than 1 year?
in General Add-Ons Support
Posted
I'd like to have OSC automatically put a product on sale if it is older than say 1 year. This would be a great way to clear out old inventory without having to manually search for old stock.
Any ideas?
Joe