Free shipping issue

[mikeel100]

Installed USPS module but server is not recognizing my website yet...

[Ajeh]

What version did you install?

Did you check the checkboxes for National and International shipping methods?

[mikeel100]

It was the most recent download available...USPS v15 Ratev4 2013_0127 R2013_0327

National...yes.

I did not check international because my dropshipper does not do shipping to overseas without first contacting them for shipping and handling.

[mikeel100]

Just so you know...

My flat rate prices (as well as the other shipping methods) are hard coded via html (in excel formulas) into my product pages and not imported into the Zencart MySQL tables.

The only shipping info that is imported directly into the Zencart db is the free shipping column (which contains 1's and 0's).

I know very little about MYSQL...simple updates to the database is about as complicated as I get. I know very little of db design, table linking, and such.

I have a gut feeling that I need to create a table or column in one of the existing tables that will link the 5 different methods of shipping rates to the SKU but I don't even know where to start.

[Ajeh]

For USPS, what happens if you get from the Plugin add ons the USPS for January 27, 2013 released on March 27, 2013:
http://www.zen-cart.com/downloads.php?do=file&id=1292

For UPS are you using the UPS add on:
http://www.zen-cart.com/downloads.php?do=file&id=1293

or the UPS XML add on:
http://www.zen-cart.com/downloads.php?do=file&id=126

You have a field that indicates what shipping to use on a Product, correct?

What happens when you have a Mixed Cart of Products that uses different shipping methods?

[mikeel100]

I have the UPS and USPS files you mentioned above. I have not messed with the XML version...it does not have dimensional support. Will it work with the stock UPS module?

USPS is still not connecting to their servers...I'm working with them on that and awaiting a reply. There website is not recognizing my website when I try to register my website with their servers.....

I have three shipping columns on my datafeed...SHIP_METHOD, SHIP_PRICE, and ALWAYS_FREE_SHIPPING. There is another column with shipping dimensions as well.

I ran a test order with 3 products, one free, one flat, and one ups. At the first level of checkout, 3 shipping estimates apprear (flat, free, and UPS). At the second level of checkout, 4 radio buttons (flat, free, UPS, and USPS) appear of which only one can be selected.

This ain't gonna work without some major changes to the shipping module.

Is there a way to make the cart process only one order at a time? It is not optimal but it is better than what I'm facing.

Recommendations?

Thanks.

[mikeel100]

The EP4 module has a method of adding fields to the datatbase. I'm going to play around with that tonight and see if I can add fields for FLAT_RATE_SHIPPING_COST and SHIPPING_METHOD. That should link the method and price with the SKU.

Once they are in the database, how would I go about making them display in the products set up page in admin and in the various pages used to display the product in the webpages?

I feel a custom shipping module coming on...LOL.

[mikeel100]

Successfully added the two MYSQL fields to the products table via EP4. I did a test upload with one product and checked the values in MYSQL. It appears to be importing the new columns correctly!

[mikeel100]

Did a test download as well to see if the new columns were included...unfortunately they are not.

Do I just need to add two new rows to the arrays where the other product attributes are listed in the easypopulate_4_export.php file?

IGNORE THIS ONE...THEY WERE DOWNLOADED....JUST NOT IN THE SAME COLUMN AS THE UPLOAD.

[mikeel100]

USPS is connecting to servers now and estimates are showing up at the first level of checkout!

So, what and where are the meat and potatoes files for making a custom shipping module that will distinguish between shipping methods and prices?