jules40 Posted April 4, 2010 Share Posted April 4, 2010 Im running version 5.2.11 (Zend: 2.2.0) I have set up the per item rate in the shipping module. I then created a test account added an item to shopping cart which underneath gives me the shipping cost estimator with the cost of shipping. I then click on checkout to the next page which is 'Payment Information' which only displays the billing address and also the method of payment which is PayPal. On the next page 'Order Confirmation' it only displays the product name of what im purchasing, the total and sub total. It is not giving me a shipping amount. Then if I click continue it takes me to the PayPal payment page which displays only the item and no shipping cost. can I also add that I have a live feed catalog of items which I sell so all the info is already in place by the supplier. What I have noticed is that every single item is set to '0' weight. Could this have something to do with the shipping amount not showing? Link to comment Share on other sites More sharing options...
♥mdtaylorlrim Posted April 4, 2010 Share Posted April 4, 2010 can I also add that I have a live feed catalog of items which I sell so all the info is already in place by the supplier. What I have noticed is that every single item is set to '0' weight. Could this have something to do with the shipping amount not showing? It could have something to do with the supplier not supplying shipping weights. Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...? Link to comment Share on other sites More sharing options...
jules40 Posted April 4, 2010 Author Share Posted April 4, 2010 It could have something to do with the supplier not supplying shipping weights. Yes it could well be... I have just installed an addon to the table rate shipping for quantity rather than weight and still even though I put 2 items in the shopping cart the shipping amount stays the same as if there is only one 'My ratios are correct' also when you go to checkout confirmation there is no shipping amount at all, only sub-total and total. Link to comment Share on other sites More sharing options...
♥mdtaylorlrim Posted April 4, 2010 Share Posted April 4, 2010 Add a weight to a product and see if it makes a difference. It really shouldn't with a per item table... Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...? Link to comment Share on other sites More sharing options...
jules40 Posted April 4, 2010 Author Share Posted April 4, 2010 Add a weight to a product and see if it makes a difference. It really shouldn't with a per item table... Yes that works, now the problem is I have 1805 products!!! Is there a way to add a weight to all products without doing them individually? Thanks Link to comment Share on other sites More sharing options...
♥mdtaylorlrim Posted April 4, 2010 Share Posted April 4, 2010 Yes that works, now the problem is I have 1805 products!!! Is there a way to add a weight to all products without doing them individually? Thanks And I have over 17k but it still only takes less than a second if you know how to use phpMyAdmin. Do you know if you even have access to it? Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...? Link to comment Share on other sites More sharing options...
jules40 Posted April 4, 2010 Author Share Posted April 4, 2010 And I have over 17k but it still only takes less than a second if you know how to use phpMyAdmin. Do you know if you even have access to it? Yes I have access to it, I have already edited a few things so I have an idea of what im doing if you could tell me how to please. Link to comment Share on other sites More sharing options...
♥mdtaylorlrim Posted April 4, 2010 Share Posted April 4, 2010 Yes I have access to it, I have already edited a few things so I have an idea of what im doing if you could tell me how to please. On the sql tab there is a text area. It may have something in it. If so it will look like this... SELECT * from `products` where 1 Replace that with... UPDATE products set products_weight = "1" Click GO. This will make ALL products have a weight of 1 regardless if there was anything in there or not. DO NOT use this if any products have valid weights you want to keep. Then, do it again with... ALTER table products modify products_weight default "1" This will make all products added have a default value of 1 if no weight is added with your scripts. That should do it. Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...? Link to comment Share on other sites More sharing options...
jules40 Posted April 5, 2010 Author Share Posted April 5, 2010 On the sql tab there is a text area. It may have something in it. If so it will look like this... SELECT * from `products` where 1 Replace that with... UPDATE products set products_weight = "1" Click GO. This will make ALL products have a weight of 1 regardless if there was anything in there or not. DO NOT use this if any products have valid weights you want to keep. Then, do it again with... ALTER table products modify products_weight default "1" This will make all products added have a default value of 1 if no weight is added with your scripts. That should do it. Thank you, the first part worked a treat and the shipping is now correct. The second part however came up with the following: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'default "1"' at line 1 Link to comment Share on other sites More sharing options...
♥mdtaylorlrim Posted April 5, 2010 Share Posted April 5, 2010 Thank you, the first part worked a treat and the shipping is now correct. The second part however came up with the following: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'default "1"' at line 1 Sorry, that was from memory. I'd have to look up the correct syntax. The only that that is intended to do is always have a value of 1 in the weight field when you add products. You can probably figure out how to do that in phpMyAdmin by editing the field in the table structure. Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...? Link to comment Share on other sites More sharing options...
jules40 Posted April 5, 2010 Author Share Posted April 5, 2010 Sorry, that was from memory. I'd have to look up the correct syntax. The only that that is intended to do is always have a value of 1 in the weight field when you add products. You can probably figure out how to do that in phpMyAdmin by editing the field in the table structure. As the supplier has a constant live feed I would like to add the syntax so that all new products have a weight of '1' I would appreciate it if you could let me know please. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.