-
Posts
29 -
Joined
-
Last visited
Everything posted by nobusiness
-
I've recently upgraded from a very old v1 oscommerce store to 2.3 and for all intensive purposes it is working. While challenging to get my modes migrated over, I'm left with one additional mod that I don't have and cannot seem to locate. I'm looking for a tax exemption module for v2.3 that I can install and have a customer enter their company name, tax exempt (yes/no), Tax Exempt ID (text) and the Organization Type (drop down - configurable by Admin only). What this code previous provided is a new Customer Type where I could create the type of Organization and a discount type (e.g. NC Correctional Institutions - Government) and another "default" as "None". Where the later is what everyone is set as a default. So, the customer can enter what they are (user or company) and if they are tax exempt or not. The admin can update the types to specify different type of companies getting the tax exemptions to comply with US Laws. The invoice and checkout processes need to also print the tax id and not have taxes included when they are exempt. I think that is it, but I'm sure I missed something. :-) Thanks, Steve
-
Hi, I've downloaded the v3 version and after installing, my local taxes are not being added to my customer orders. I've looked at all the changes and I cannot see what it is that would cause it to not show during checkout or on the invoice. My taxes are based on the state of NC in the USA. If anyone has ideas, I'd love to hear them since I've had to back charge customers for taxes not taken out which is not good for business. :mellow: Thanks! - Steve
-
USPS Rate V4, Intl Rate V2 (official support thread)
nobusiness replied to a topic in Shipping Modules
Okay, I have a more pressing matter. Since installing the module, my tax module is not working for local orders. I had just received an order from my own state and the taxes should have been included in the invoice/order and it was not. I just confirmed in a test account that this is true for all locations in my state. I have tax module for North Carolina - USA installed. Anyone know why it would stop working? -
USPS Rate V4, Intl Rate V2 (official support thread)
nobusiness replied to a topic in Shipping Modules
Thank you for the details. I found the ideal place to include it in the catalog/checkout_shipping.php file. I searched for TABLE_HEADING_SHIPPING_METHOD; and found this section around line 254: <tr> <td class="main"><b><?php echo TABLE_HEADING_SHIPPING_METHOD; ?></b></td> </tr> and replaced it with: <tr> <td class="main"><b><?php echo TABLE_HEADING_SHIPPING_METHOD; ?></b><font color="brown"> <b>Note:</b> For USPS flat rate shipping selections, call first for details.</font></td> </tr> This added the message on the checkout screen just above the shipping options and to the right of "Shipping Method" label. Worked perfectly!! Thanks again, Steve -
USPS Rate V4, Intl Rate V2 (official support thread)
nobusiness replied to a topic in Shipping Modules
I looked at the page in question, but I couldn't determine where I could add a note/text in it to be visible on the checkout screen. Could you tell me which text to look for that I can add it into it? Thanks! -
USPS Rate V4, Intl Rate V2 (official support thread)
nobusiness replied to a topic in Shipping Modules
If we choose the later in the above to make the selections fewer and store determine shipping containers, I still would like a note field to add to the customer for situations like if a storm is interfering with shipping and there may be delays, we can state that in the shipping screens so the customer is aware of potential delays due to weather or other factors. -
USPS Rate V4, Intl Rate V2 (official support thread)
nobusiness replied to a topic in Shipping Modules
I think what is also missing from this module is a note to the customer about "flat rate" selections. The customer cannot really decide which package (envelope, small box, medium box or large box) as that would be up to the store to determine what the product fits in. So if a customer picks small box and the product doesn't fit, then what? There should be a note field as part of the shipping selections under the admin panel for the store to add notes which appear in BOLD RED , with a default description of - Shipper determines actual shipping method for flat rate containers, additional fees may be charged. The shipper then would need a way to either charge the customer the difference (negative or positive amounts). Cancelling the order and re-doing it just isn't a good way to handle a shipping container issue. If you look at other merchants, you select USPS, UPS, FedX and whether you want it next day, same day or standard delivery and then the shipper determines the best method based on the customers request and charges made to their account. I think this module could be simplified a lot, have less to check (in the admin screen) and leave the actual shipping container selections to the store. -
USPS Rate V4, Intl Rate V2 (official support thread)
nobusiness replied to a topic in Shipping Modules
I ran into the same problem Brett. You have to check the boxes next to each shipping option when you enable and add your USPS Shipper's ID. Otherwise, nothing shows up. There were no instructions that this was a required step so it is easily overlooked. :-) -
USPS Rate V4, Intl Rate V2 (official support thread)
nobusiness replied to a topic in Shipping Modules
I guess it helps to check the boxes next to the shipping services I want enabled. :-) Thanks!! -
USPS Rate V4, Intl Rate V2 (official support thread)
nobusiness replied to a topic in Shipping Modules
Yes, my production ID was received and added to the configuration. I'm just not seeing a shipping option (as a customer) for USPS, only UPS (which was the default previously). -
USPS Rate V4, Intl Rate V2 (official support thread)
nobusiness replied to a topic in Shipping Modules
I just installed the new version and when I go through the check out, all I see is UPS as an option. I've selected USPS as 1 and UPS as 2 in the order of services. My country and zip are already set, and the USPS is set to true (enabled). Any ideas? Thanks, Steve -
How to setup a town/city for free local delivery in MultiGeoZone?
nobusiness replied to papagino's topic in Shipping Modules
One thought I had was that I wish I could just have a field on the customer account that I could update and set a field for: ChargeShipping=No/Yes ChargeTax=Yes/No For those customers without these fields, shipping/tax calculates as normal. However, for those customer(s) with these fields, shipping is either displayed as usual or not (if No) and Pick Up is the default. For taxes (if NC in my case) they are applied or not based on buyers address, not pickup location. Currently, if I choose to have a Pick Up instead of shipping, taxes are not based on the buyers location, but on the shippers location. So if I'm delivering it myself, then the taxes should be based on where it is being delivered to in that case. -
How to setup a town/city for free local delivery in MultiGeoZone?
nobusiness replied to papagino's topic in Shipping Modules
Hi, I have a similar case where I have one customer who I want to offer free shipping to and deliver the products myself. The problem I am facing is two fold. First the customer is in another city and county in the same state and the tax rate is different for their county than mine, so I have to make sure their order includes the correct taxes, but I want the shipping cost to be zero. I looked at discount codes, but they are applied before shipping/taxes and that is incorrect. I tried to use the pickup rate module which is active on my site, but while the shipping charge is zero, the tax rate is incorrectly charged based on my location, not theirs. I think if I had an option to add another location, with the customers address and use it for pickup rate, I think that would do it, but I don't see any option to configure this. Can anyone help me on this? Thanks!! Steve -
I followed the directions and installed the files as instructed (and just for the record, I'm not a PHP programmer). I'm pretty sure all the files are in the right places and everything appears to be in place. However, when I go to tools|generate pdf catalog, I get this: 1054 - Unknown column 'p.products_id' in 'on clause' select p.products_id, pd.products_name, pd.products_description, p.products_image, p.products_model, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id='35' order by pd.products_name, p.products_date_added DESC Is there something on the DB side I have to do as well? Didn't see anything in the zip file about that. I downloaded the 9/2008 version of the PDF Catalog module. I did research and found that this msg comes up when left joins are used and no () are used. Not sure which file is causing the issue, so I guess that is the problem. I emailed snarg for help, but haven't heard anything yet so opening this up for anyone else who's run into this or knows of a solution. Regards, Steve
-
Trying to get the NC Tax stuff to work, but no taxes are being charged. I ran the SQL, the details are in the DB, but no taxes are charged for Out of State or In State customers. What's missing?
-
I'm trying to add additional links to the infobox, but not having any success. I'm also looking a doc that illustrates how to make changes to each section (correctly)....like I found out that the changes made to the \english\ directory php files is where they need to be made and not the ones in the public_html\ directory. When I try to add a link in the information.php file using the format in it, the file is never found. So I'm expecting there are more than 1 or 2 files that need to be setup to find it correctly. It would be greatful if someone could let me know where to find help on this topic. Thanks, Steve :rolleyes: