osCommerce Community Support Forums: pafranklin - Viewing Profile

Jump to content

Corporate Sponsor


pafranklin's Profile User Rating: -----

Reputation: 0 Neutral
Group:
Community Member
Active Posts:
244 (0.15 per day)
Most Active In:
General Support (155 posts)
Joined:
04-October 05
Profile Views:
5,522
Last Active:
User is offline Feb 20 2010 10:38 AM
Currently:
Offline

Latest Visitors

Icon   pafranklin has not set their status

Topics I've Started

  1. API Certificate v API Signature

    Posted 20 Feb 2010

    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
  2. Error on Copy Product

    Posted 24 Jan 2010

    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
  3. UK VAT Changes 2010 - Updating Prices & Specials Prices

    Posted 30 Dec 2009

    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
  4. Limiting a Payment Module by Customer Group?

    Posted 12 Sep 2009

    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
  5. Opening Links in a new Window

    Posted 1 Aug 2009

    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

    <td class="main"><?php echo tep_image(DIR_WS_IMAGES . 'arrow_green.gif') . ' <a href="' . tep_href_link(FILENAME_STATS_LOW_STOCK, '', 'SSL') . '">' . MY_OREPORTS_VIEW . '</a>'; ?></td>


    Many thanks.

    Paul

My Information

Age:
47 years old
Birthday:
January 25, 1963
Real Name:
Paul Franklin
Gender:
Location:
Gloucestershire, UK
Interests:
OSC (Obviously), general website design, cricket, cinema and theatre. Oh yes - and red wine!
Add-On Dev:
Yes

Contact Information

E-mail:
Click here to e-mail me
Website URL:
Website URL  http://www.pianocoversonline.co.uk/

Comments

pafranklin has no profile comments yet. Why not say hello?