kwalker Posted December 1, 2005 Share Posted December 1, 2005 Hello all, Let say I have 4 suppliers, and for each of the suppliers I want to assign their products in the manufacturers section. Since there are 4 suppliers/manufacturers, can the shipping be based on the manufacturer?s zip code? I was wondering about using the manufacturer?s zip code field as a ?key? field if possible. I was hoping maybe someone has run into this situation before. Since those products don?t come from my location, I want the shipping cost to be based coming from the manufacturer?s zip code. I?ll have a zip code box for all my products, so before a person checks out, they can enter in their zip code and get shipping cost. I am using the FedEx Freight Shipping Contrib., and it works great. I was thinking of a way to pass the manufacturer?s zip code to the "FedEx Contrib." before it gets submitted. Thanks for your valued time. Kevin "What I didn't know yesterday, I know today & will remember tomorrow" (By Kwalker) What do you see when you open up the tep_database-pr2.2-CVS.pdf file that came with your osCommerce download? Link to comment Share on other sites More sharing options...
wheeloftime Posted December 1, 2005 Share Posted December 1, 2005 Hello all, Let say I have 4 suppliers, and for each of the suppliers I want to assign their products in the manufacturers section. Since there are 4 suppliers/manufacturers, can the shipping be based on the manufacturer?s zip code? I was wondering about using the manufacturer?s zip code field as a ?key? field if possible. I was hoping maybe someone has run into this situation before. Since those products don?t come from my location, I want the shipping cost to be based coming from the manufacturer?s zip code. I?ll have a zip code box for all my products, so before a person checks out, they can enter in their zip code and get shipping cost. I am using the FedEx Freight Shipping Contrib., and it works great. I was thinking of a way to pass the manufacturer?s zip code to the "FedEx Contrib." before it gets submitted. Thanks for your valued time. Kevin As far as I know there is no manufacturers zip code with osC but you could create such field of course and thus create a simple way to achieve what you want. I don't know the FedEx contrib but if it works like others the shop's zip code as entered in the admin is send to the shipper as being the originating zip code. Now if you replace that zip code with the manufacturers one for that product you are already done. HTH Link to comment Share on other sites More sharing options...
kwalker Posted December 1, 2005 Author Share Posted December 1, 2005 You Wrote: Now if you replace that zip code with the manufacturers one for that product you are already done. That sounds about right. That would work... but now I think about, you would need to enter a zip code for the product somewhere, and the FedEx Freight Contrib only sets the zip code for the whole store, but NOT each product. Now that would be a great idea,,, in ANY shipping contrib, make it to where you can set the shipping info for ANY product. There is a Contrib listed here that will put all of your "Attributes" in "Groups"... I see it similar to that contrib. wheeloftime, you gave me something to think about that I didn't think of before. Although I still face the obstacles ahead, your reply gave me some great ideas.... just from that one idea. I'm going to see if it's possible to add a shipping zip code to any product, then send it in for processing to the shippers. Kevin "What I didn't know yesterday, I know today & will remember tomorrow" (By Kwalker) What do you see when you open up the tep_database-pr2.2-CVS.pdf file that came with your osCommerce download? Link to comment Share on other sites More sharing options...
wheeloftime Posted December 1, 2005 Share Posted December 1, 2005 You Wrote: Now if you replace that zip code with the manufacturers one for that product you are already done. That sounds about right. That would work... but now I think about, you would need to enter a zip code for the product somewhere, and the FedEx Freight Contrib only sets the zip code for the whole store, but NOT each product. Now that would be a great idea,,, in ANY shipping contrib, make it to where you can set the shipping info for ANY product. There is a Contrib listed here that will put all of your "Attributes" in "Groups"... I see it similar to that contrib. wheeloftime, you gave me something to think about that I didn't think of before. Although I still face the obstacles ahead, your reply gave me some great ideas.... just from that one idea. I'm going to see if it's possible to add a shipping zip code to any product, then send it in for processing to the shippers. Kevin Kevin, That is not neccessary ! If in your situation every product is tied to SOME manufacturer you only have to add a zip code to the manufacturers table. In the end you query for the manufacturers zip code to determine the origin of the package which you send to the shipper. There is of course the problem that different products can come from different manufacturers and so you could have the situation that ie. 2 products come from manufacturer A and 2 other products from manufacturer B. That would mean two different packages with two different shipping costs. regards, Howard Link to comment Share on other sites More sharing options...
kwalker Posted December 1, 2005 Author Share Posted December 1, 2005 That is exactly what I need to do. Somehow tie in the 4 manufacturers and associate them to certain products. Do you know of any program that would help convert .cgi into .php? I have a script I've put together over a year ago, and it would do it for 1 manufacturer. Once I convert it over to .php, I could add the other manufacturer's zip codes to it to make it work. Then I'll have to incorporate it into the osc. Kevin "What I didn't know yesterday, I know today & will remember tomorrow" (By Kwalker) What do you see when you open up the tep_database-pr2.2-CVS.pdf file that came with your osCommerce download? Link to comment Share on other sites More sharing options...
wheeloftime Posted December 1, 2005 Share Posted December 1, 2005 That is exactly what I need to do. Somehow tie in the 4 manufacturers and associate them to certain products. Do you know of any program that would help convert .cgi into .php? I have a script I've put together over a year ago, and it would do it for 1 manufacturer. Once I convert it over to .php, I could add the other manufacturer's zip codes to it to make it work. Then I'll have to incorporate it into the osc. Kevin I have no idea about .cgi to .php but I wonder if that is neccessary ? I probably don't understand your situation completely but the only thing you would have to do is add a zip code field to the manufacturers table and assign the manufacturers to the products (which you maybe already did). Than decide at which point you want to swap the shop's zip code for the manufacturers zip code (preferably at the start of checkout shipping I guess) and that should be it. These are really some small code changes and I don't think you would need to convert any .cgi solution you now have to accomplish this. Link to comment Share on other sites More sharing options...
kwalker Posted December 1, 2005 Author Share Posted December 1, 2005 wheeloftime, Thanks for your input. After doing some searches here, I came across a thread that was started last year and it talks about doing exactly what I am wanting to do. It's a contrib called "Multi Vendor Shipping". I'm following the thread, and I just downloaded the contrib, but haven't installed it. Hope it works for me. Kevin "What I didn't know yesterday, I know today & will remember tomorrow" (By Kwalker) What do you see when you open up the tep_database-pr2.2-CVS.pdf file that came with your osCommerce download? Link to comment Share on other sites More sharing options...
wheeloftime Posted December 1, 2005 Share Posted December 1, 2005 wheeloftime, Thanks for your input. After doing some searches here, I came across a thread that was started last year and it talks about doing exactly what I am wanting to do. It's a contrib called "Multi Vendor Shipping". I'm following the thread, and I just downloaded the contrib, but haven't installed it. Hope it works for me. Kevin Hi Kevin, I don't know that contrib, obviously, and it indeed sounds as exactly what you need. If it is you are set and ready to go :thumbsup: Grtz. Howard Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.