Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

lbennett

Pioneers
  • Posts

    38
  • Joined

  • Last visited

Everything posted by lbennett

  1. Please provide more information. Do you have an SPPC group called retail? Have you followed all SPPC installation instructions? In the admin > My Store page do you have "Display prices with tax" set to true? This should always be set to true for SPPC. In the admin > Customers > Customers groups > Retail page have you set "Show prices with/without tax " to "Show prices with tax"? Have you set the correct prices for your items? Do you have a group for which prices are displayed without tax? If so, is the correct price being displayed for this group?
  2. I've added the code you recommend but now the shipping price on the Order Confirmation page always excludes tax (before it always included tax) no matter what the group setting for display tax is. How can I see the value of DISPLAY_PRICE_WITH_TAX, $tax and $customer_group_show_tax at this point in the execution of the code?
  3. Thanks Jan, I've just realised from the code that you recommend that I have been confused between CUSTOMERS with an S and CUSTOMER without an S. In the customers_group table in the database the field is customers_group_show_tax (customers with an S) but in the code from includes/functions/general.php there is no customers with an S. I'll let you know how it works out now.
  4. I posted this yesterday but the SPPC thread is that big I had trouble finding my own post so I thought I should post it under a new thread and someome may read it then. I have an ongoing problem with the shipping price for members of SPPC groups that are set to display prices without tax. The shipping price passed to the credit card gateway is what ever is shown as the shipping price on the Order Confirmation page, however, this always includes tax because "SHOW_PRICES_WITH_TAX" is always set to true for SPPC, therefore, the shipping price on the order conformation page always includes tax no matter what the customers group is set to for displaying tax. The shipping price displayed on the Order Confirmation page comes from catalog/includes/modules/order_total/ot_shipping.php and I changed the following line in that file if (DISPLAY_PRICE_WITH_TAX == 'true') $order->info['shipping_cost'] += tep_calculate_tax($order->info['shipping_cost'], $shipping_tax); to if (CUSTOMERS_GROUP_SHOW_TAX == 'true') $order->info['shipping_cost'] += tep_calculate_tax($order->info['shipping_cost'], $shipping_tax); but the shipping price still shows tax for a member of an SPPC ex-tax group as if it always defaults to 'true'. If I can resolve this then I think I will also resolve the problem with the tax in the credit card module as the code for passing tax to the gateway is similar.
  5. This is still an ongoing problem for me. The shipping price passed to my credit card gateway is what ever is shown as the shipping price on the Order Confirmation page, however, "SHOW_PRICES_WITH_TAX" is always set to true for SPPC, therefore, the shipping price on the order conformation page always includes tax no matter what the customers group is set to for displaying tax. The shipping price displayed on the Order Confirmation page comes from catalog/includes/modules/order_total/ot_shipping.php and I changed the following line in that file if (DISPLAY_PRICE_WITH_TAX == 'true') $order->info['shipping_cost'] += tep_calculate_tax($order->info['shipping_cost'], $shipping_tax); to if (CUSTOMERS_GROUP_SHOW_TAX == 'true') $order->info['shipping_cost'] += tep_calculate_tax($order->info['shipping_cost'], $shipping_tax); but the shipping price still showns tax for a member of an SPPC ex-tax group as if it always defaults to 'true'. If I can resolve this then I think I will also resolve the problem with the tax in the credit card module as the code for passing tax to the gateway is similar.
  6. Whilst this refers to a credit card payment module I think my problem is my lack of understanding of PHP variables and syntax. I have SPPC installed, therefore, DISPLAY_PRICE_WITH_TAX which was originally in line 4 of the code below always has to be set to true. Whether prices are displayed including or excluding tax under SPPC is dependant on CUSTOMERS_GROUP_SHOW_TAX, a field in the customers_group table of the database. Searching through the code I also came across $sppc_customers_group_show_tax. I've tried replacing DISPLAY_PRICE_WITH_TAX with both CUSTOMERS_GROUP_SHOW_TAX and $sppc_customers_group_show_tax but in each case the results indicate the value is "false". Following is the section of code in question which should pass $0 if CUSTOMERS_GROUP_SHOW_TAX == 'true' but passes the tax amount as if CUSTOMERS_GROUP_SHOW_TAX == 'false'. //Taxes foreach($order->info['tax_groups'] as $name => $value) { if ((float)$value > 0){ if (CUSTOMERS_GROUP_SHOW_TAX == 'true'){ //If the prices are displayed with tax add the description of the tax as a product with $0 value //This will make sure the tax details are displayed in the payment page //$0 value will make sure the tax is not added AGAIN to the order total $gateway_vars[number_format((float)$value, 2, '.', '').' '.$name.' '.MODULE_PAYMENT_NAB_TRANSACT_HPP_PROD_DESC_TAX_INCLUDED] = '1,0'; } else { $gateway_vars[MODULE_PAYMENT_NAB_TRANSACT_HPP_PROD_DESC_TAX.': '.$name] = '1,'.number_format((float)$value, 2, '.', ''); } } } Any help would be appreiciated.
  7. Oops. Forgot to past the code in the last message. $gateway_vars[MODULE_PAYMENT_NAB_TRANSACT_HPP_PROD_DESC_SHIPPING.': '.$shipping_desc] = '1,'.number_format((float)$order->info['shipping_cost'], 2, '.', '');
  8. This looks like the line in the NAB module that gets the shipping cost. Where would I find the shipping cost displayed on the shipping method page?
  9. Hi Jan, Thanks for your reply. It looks like the problem is in the NAB Transact gateway module. Here is an example of what is happening. Order Confirmation page. Item ex-tax = $54.55 Shipping incl. tax = $10.79 Tax = $6.44 (54.44 + 9.81 (shipping ex-tax)*10%) Surcharge = $1.70 Total = $72.49 NAB Transact page (Bank website) Item ex-tax = $54.55 Shipping incl. tax = $10.79 Tax = $6.44 Surcharge = $1.70 Total = $73.48 It looks like I'll have to figure out where the shipping is being sent to the bank and get it to send the ex-tax price for shipping. The developer for this module is too busy to look at it at the moment. Can you suggest what I should be looking for in his code? Thanks, Lester
  10. Still need help with this one. I thought I had solved the problem but I hadn't. Sending details to the NAB credit card gateway for a customer that is in a group that has "Show Prices with/without Tax" set to WITH works correctly. However, the correct details are not sent for a customer in a group for which the setting is WITHOUT. For this customer the shipping prices are shown excluding tax but when you get to the Order Confirmation page the shipping price is shown with tax. This is the shipping price that is sent to the gateway along with the correct tax, therefore, the tax is charged twice. How do I change the shipping on the Order Confirmation page to show and pass on the ex-tax price for customers in a group set to show prices WITHOUT tax?
  11. Please ignore my previous posts in this thread. I just realised that my test accounts had different postcodes, hence, different shipping costs. Ploblem is solved. -
  12. OK. I have now set My Store > Show Prices with Tax to true. The shipping cost ex-tax is $9.81 I have one group "Consumer" that it set to Show Prices WITH Tax and Tax Exempt = No. Shipping is shown as $10.79 (includes tax) on both Shipping Method and Order Confirmation pages. Tax is calculated on item plus $9.81 I have another group "Dealer" this is set to Show Prices WITHOUT Tax and Tax Exempt = No. Shipping is shown as $10.41 on the Shipping Method page and $11.45 on the Order Confirmation page. Tax is calculated on item plus $10.41. Can someone tell me how is the Dealer group is being charged a different shipping price? It is not even tax on tax. ($9.81 + 10% = $10.79 + 10% = $11.87).
  13. Show price with/without tax for shipping on Checkout Shipping and Order Confirmation page do not seem to be based on the setting for the current customer group (CUSTOMERS_GROUP_SHOW_TAX). These seem to be based on the My Store setting for "Display Prices with Tax" (DISPLAY_PRICE_WITH_TAX). This is causing a problem because I have some groups with tax displayed and some without. How can I set the inclusion or exclusion of tax in the shipping price on these pages to depend on the setting for the current customers group id and display of prices before login based on the default group 0?
  14. I have a problem with the NAB Transact credit card payment module because I have SPPC installed. The NAB module uses the admin > My Store > Show Prices with Tax setting to determine whether tax is already included in the item price. The developer is too busy with paid work to have a look at it at the moment and my php knowledge is limited. The NAB module currently uses DISPLAY_PRICE_WITH_TAX to determine this. It looks like I should be changing it to use CUSTOMER_GROUP_SHOW_TAX. Am I on the right track?
  15. I'm using the latest NAB Transact module and also use Separate Price Per Customer and a number of groups for different levels of resellers. Consumer accounts see prices including GST and this is sent to NAB Transact included in the item price and a listing for GST of $0 which is OK. However, the reseller accounts are set to see prices excluding GST and GST is calculated on the total of items and shipping on the checkout page but the GST is not being passed to NAB Transact. On the NAB Transact page the items are listed at their exGST prices as is Shipping but the GST is still shown as $0. Can anyone out there using this module and displaying exGST prices confirm whether it is working correctly for you? I've been in touch with Dushy the developer of the module but he is busy with paid work at the moment and doesn't know when he will get a chance to have a look at it. For now I just want to know if it is happening for others and, therefore, in the module or if it's the result of some other change on my site.
  16. I have the same issue only because there is a "Checkout with Paypal" button on the "What's in my Cart?" page as well as a "Continue" button. If you click on "Checkout with Paypal" at this stage it takes you to Paypal without shipping and other charges added. If I click "Continue" I can select shipping method then continue to payment method and select Paypal Express it all appears to be OK. If I can remove the "Checkout with Paypal" button from the "What's in my Cart?" page there wouldn't be a problem. Can anyone tell me what code has to be removed from what file to remove this button?
  17. Did you ever find a solution for Couriers Please?
  18. I've worked it out. The line should be; if ($customer_group_id != '0'){
  19. While this is not directly related to SPPC it is related to groups and I thought someone that reads this thread may be able to help. I don't want visitors to our osCommerce site to be able to add items to their cart until they log in. The site is a mixed retail and wholesale site and the public can't buy some items direct. Therefore, I don't want the "Add to Cart" button available unless the visitor is logged in at which time they are no longer in the "Retail" group. I'm php illiterate but gradually learning. I thought something like the following in product_info.php would do it but don't know the syntax to test for group_id not 0. <!-- BEGIN Hide Add to Cart until logged in --> <?php test to see that group_id is not 0 ?> <td class="main" align="right"><?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?></td> <?php } ?> <!-- END Hide Add to Cart until logged in -->
  20. Thanks Sam. I added your suggestion around the line that displays the "Add to Cart" button in product_info.php but now it doesn't show at all. Logged in or not. Here is what I did; <!-- BEGIN Hide Add to Cart until logged in --> <?php if (tep_session_is_registered(customer.id)) { ?> <td class="main" align="right"><?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?></td> <?php } ?> <!-- END Hide Add to Cart until logged in -->
  21. How do I change the default group. I posted this under the General forum because I thought it was a general question but got no responses. Hopefully, someone here may have an answer. When someone creates an account online it is added to the group "Retail" by default. Because of my store setup I'm using the default "Retail" to display all products but prevent purchase by removing the "Add to Cart" button unless logged in. I would like to use another group ("Registered") for users that register online then they will get the "Add to Cart" button and a restricted list of categories when they login due to the SPPC and HPC4SPPC add-ons . Where do I change the default group for account creation but not the site default group? In fact, where do I change the site default group?
  22. Menathor thank you for your contribution. I am looking for a variation on this. I would like to hide the "Add to Cart" for non-logged in users. I've looked at your code but I am not proficient in PHP. I guess there is a variable to indicated where the user is logged in and I should test for that and hide the icon if not logged in. Any help would be appreciated.
  23. Do a download of each of the available .csv options then open them with OpenOffice or Excel and you will have the structure for your new spreadsheet. Remove all current data from the one you want to use by deleting all but the top row. Cut and paste from your existing spreadsheet into the correct columns in the new one. Make sure all rows end with EOREOR. Save as a .csv file. Upload it with Easy Populate. Couldn't be easier.
  24. No need to beg again. I just need to get my brain in gear. Thanks surfalot
×
×
  • Create New...