osCommerce Community Support Forums: pafranklin - Viewing Profile

Hi there,


I am hoping to install this version but see that you need an API Certificate? Unfortunately I have (and still use) the more modern API Signature. According to PayPal you cannot have both an API Certificate and an API Signature.

Is there away around this?

Will this module be upgraded to use the API Signature method?

Any comments would be greatly appreciated.

Many thanks.

Paul

Hi there,

I am attempting to copy a product (duplicate rather than link product) from one category to another. I have the Bulk Copier contrib installed but this copies the products as linked products instead of duplicate ones, so is not suitable.

Therefore I decided to use the normal Copy button from the categories.php page (when viewing the products category.

However, I select the product, put a tick in the "Duplicate Product" box and then click the copy button.

I receive an error message that says....

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

insert into products_shipping (products_id, products_ship_methods_id, products_ship_zip) values ('2342', '0', ''

[TEP STOP]

Please would someone assist with solving this or perhaps point me in the right direction. Clearly it is something not right on my categories.php file but I am not sure where to look or how to fix?

Many thanks in advaice!

Paul

Hi there,

We are just a few days away from the UK VAT rate increasing back to 17.5%, but I would like to keep my gross prices the same and not increase them form our customers, so I am looking to identify a script that can reduce the net prices in phpMyadmin once I have changed the tax rate back from 15% to 17.5%.

I believe that I need to change both the product price and the specials price? Is this correct?

I have started to work on a script but would like someone to have a look at this before I attempt to use it as I am not sure that these will work???...........

a. To update products_price:

UPDATE products SET products_price = products_price /1.0217

b. To update Specials net prices

UPDATE specials SET specials_new_products_price = specials_new_products_price /1.0217

Any help would be appreciated please?

Many thanks.

Paul

Hello,

I am after a pointer please if anyone has come across this? I have looked through the forums but have not found anything yet.

I am looking at installing a module to categorise or group customers into retail or Wholesale groups for example. Is it possible and if so "How", to display only certain payment modules for one of the customer groups?

Any pointer would be a great help.

Many thanks.

Paul

Hi there,

Probably a really stupid question but I have a link that I want to have open in a new window. How do I change the code below to enable this please??

Quote

Many thanks.

Paul