First some up front info:

I modified the Table Rate (table.php) module and made my own in order to calculate prices based on the product type and the number ordered. My Shipping Table values I entered are: C-1:2.99,C-2:3.50,C-3:4.00,C-10:4.50,C-10000:0.25,A-1:6.99,A-10000:1.00,G-1:5.00,G-10000:1.00 and it works fine, giving me the correct shipping cost using the shipping estimator as long as I'm logged in.

Now, the way I get my list of products in my_table.php is by using the following SQL statement:

Code:
$products_query = "select p.products_type, cb.customers_basket_quantity 
                            from " . TABLE_PRODUCTS . " p, " . TABLE_CUSTOMERS_BASKET . " cb 
                            where cb.customers_id = '" . (int)$_SESSION['customer_id'] . "' 
                            and p.products_id = cb.products_id";
I then run through the array and get the quantities for each product type (comic book, graphic novel, or artwork). Shipping varies based on the product.

I would like to be able to get a shipping value for someone who hasn't logged in yet, but I'm not sure where to get the values if they haven't been written into the database yet. Right now, I'm getting a $0.00 shipping value.

Any help is appreciated, and if you need more information, let me know.

Thanks!