Quote:
|
Originally Posted by spingary
Joelrhome,
No no-- the MySQL part is not to add a field to the xcart_shipping table. All we are doing is adding a row to that table. You can go to the "Patch/Upgrade" area, under the Apply SQL Patch, type in this in the query(ies) box:
Code:
INSERT INTO xcart_shipping VALUES (103, 'Free Shipping - Orders Over $200', '', 'L', 'FREEOVERX', '201', 5, 'Y', '', '0.00', 0);
As for your question regarding real-time shipping, yes the other real-time shipping methods will continue to work fine. This method is to add another real-time shipping method to be available to your customers in their cart if their order amount is over $X.
Hope this helps,
Gary |
Would you please give a step-by-step instruction? When reading your previous post, I thought I need to add that to the MySQL database, but after reading this post, I have learned it should be added to the patch file.
Now, after I added the above to the patch file, I have got:
PATCH RESULTS
SQL PATCH FAILED AT QUERY:
INSERT INTO xcart_shipping VALUES (103, 'Free Shipping - Orders Over $50', '', 'L', 'FREEOVERX', '201', 5, 'Y', '', '0.00', 0)
Please help! thanks.