Jump to content

PaulOB

Members
  • Content count

    47
  • Joined

  • Last visited

Profile Information

  • Real Name
    Paul O'Brien

Recent Profile Visitors

5,102 profile views
  1. PaulOB

    Multi_Vendor_Shipping new thread

    Enter product prices in different currencies - Help with product currency in MVS... I have set up my store to automatically update exchange rates several times a day so products can be displayed in various currencies. However, I have vendors which supply goods in different currencies e.g. USD, EUR and GBP. There have been very large fluctuations in exchange rates recently, so what I would like to do is be able to set the Net Product Price in the same currency that the vendor supplies the goods to me. The great majority of goods are bought in my default currency, but recently I have found I could easily have made losses on products that are not bought in the default currency due to exchange rate movements... Can this be done by creating a new column (let's say products_currency) in the products table and making changes in admin/categories.php ( and I suppose admin/includes/languages/.../categories.php as there'd need to be a box to enter the currency or left blank ) ? Can anyone provide the code to do this?
  2. PaulOB

    Multi_Vendor_Shipping new thread

    Suggested improvement - MVS Product Attributes - vendor option price I was PM'd today regarding making a Product Attributes mod work with MVS... The mod is one which allows weight differences to be applied to product attributes... I've been using MVS for over 2 years now, and had always just lived with the minor annoyance that the purchase order e-mailed to the vendor didn't take into account any price modifier when product attribute options resulted in a price difference - i.e. the purchase order would always quote the base price. On numerous occasions vendors have e-mailed me about incorrect amounts been shown on the purchase order e-mail they received because of this. Anyway, the add weight to product attributes looks quite neat (http://www.oscommerce.com/community/contributions,1622) and I thought a similar approach could be adopted to MVS that could allow a vendors product attribute price change i.e. altering SQL table products_attributes to add a column for the price the vendor charges (or deducts) for the option. The same sort of code changes could be applied to catalog/admin/product_attributes.php & catalog/admin/includes/languages/english/product_attributes.php ; and a minor change in catalog/admin/vendor_email_send.php As it's so long since I've checked these forums I thought I'd see if anyone has done this already? I thought Craig or Jim may have some ideas and was surprised that MVS is still version 1.1 !!! Paul.
  3. PaulOB

    Multi_Vendor_Shipping new thread

    Hi Daniel, I've done a modified zones module that will work with states as well as countries. I'll upload to the contributions section. Best regards, Paul.
  4. PaulOB

    Multi_Vendor_Shipping new thread

    Thanks again Jim! Paul.
  5. PaulOB

    Multi_Vendor_Shipping new thread

    I'm trying to create a shipping module for MVS based on the zones module. It is for vendors who ship by haulage where their shipping rates are determined by part of the UK postcode. Since uploading this module to the vendors_shipping folder and associated language file to includes\languages\english\modules\vendors_shipping, I am getting this error message when I click manage vendors: Call to undefined function: zones() in /.../admin/vendor_modules.php on line 143, referer: http://.../admin/vendors.php?selected_box=vendors&page=1&vendors_id=3 These are the files I've uploaded: http://www.biofuelsystems.com/other/mvspostcodes.zip The zones.php module was working fine prior to this. Any ideas what's gone wrong??
  6. PaulOB

    Protx Direct v2.22

    Thanks Tom. With Protx Form the customer would have to select the type of card they are using before they are directed to Protx when they could in theory use another type of card i.e. select debit card in the online store (no charge) and pay with a credit card when they get to Protx (instead of paying the surcharge) Would agree Protx Direct is a better method, and I think ultimately I will be switching to it regardless of whether I can get the surcharge system working they way I'd like it to... For my store there are items where the margin is so low that the fees charged on certain credit cards (e.g. commercial credit cards) swallow up almost all the profit. I'd like to be able to set whether a credit card surcharge is applied on any given item as for the great majority of items I wouldn't have to do it... All the best, Paul.
  7. PaulOB

    Protx Direct v2.22

    It would be even better to be able to apply credit card surcharges to certain items only, but clearly this will be quite complicated as a separate order total for items to which the surcharges apply would have to be passed to the payment module...
  8. PaulOB

    Protx Direct v2.22

    The margins on some the items I am selling are very low (less than 4% in some cases) and for this reason I would like to be able to apply surcharges for certain types of card. At the moment I am using Protx Form, but would like to start using Protx Direct as presumably there is scope to modify this module to allow this - ideally an extra menu from the admin screen where either flat rate or percentage surcharges could be applied for different card types. Can anyone help with this? Paul.
  9. PaulOB

    Multi_Vendor_Shipping new thread

    Hi Jim, Just a quick note to point out that a bug you had previously found in the admin/invoice.php file whereby product attributes / options were not displaying for all but the first product ordered seems to have crept back in to the contribution... ref: Almost at the bottom of this page - http://forums.oscommerce.com/lofiversion/i...01973-1050.html - you made this code change: <code>echo '<br><nobr><small> <i> - ' . $order->products[$l]['orders_products'][$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['orders_products'][$i]['attributes'][$j]['value']; </code> A close examination of that line shows that the first index on the Value is an i where it should be l. Another reason why I won't use single-letter variables. Here's the correct line: <code>echo '<br><nobr><small> <i> - ' . $order->products[$l]['orders_products'][$i]['attributes'][$j]['option'] . ': ' . $order->products[$l]['orders_products'][$i]['attributes'][$j]['value']; </code> All the best, Paul.
  10. PaulOB

    Protx Direct v2.22

    Hi Vger, I'm not sure if you're replying to me, but I'm using VSP Form and have never had to set up a list of IP addresses. Paul
  11. PaulOB

    Protx Direct v2.22

    Hi, I've just moved my site & shop to a new server, and have tried some test transactions, but it no longer gets back to the checkout success page - just a blank screen... Can't understand what the problem could be as it was working fine prior to this... Can't think what might have changed. Any help gratefully received, as this is going to cause big problems - the shop has been live for some time... Paul.
  12. PaulOB

    Multi_Vendor_Shipping new thread

    In checkout_process, how can I include the quoted vendor shipping rate in the e-mail to the vendor? (I want the vendor to be able to check each time that we haven't undercharged for shipping) Cheers, Paul.
  13. PaulOB

    Multi_Vendor_Shipping new thread

    For now, I have created a new funtion in general.php so that this can be done: // Add tax to a products price for invoices function tep_add_tax_invoice($price, $tax) { global $currencies; if ( $tax > 0 ) { return tep_round($price, $currencies->currencies[DEFAULT_CURRENCY]['decimal_places']) + tep_calculate_tax($price, $tax); } else { return tep_round($price, $currencies->currencies[DEFAULT_CURRENCY]['decimal_places']); } } Not sure it's the best way to go about it though... - Paul -
  14. PaulOB

    Multi_Vendor_Shipping new thread

    I think I've found the source of my problem, but I'm not sure what to do about it... I want to be able to show the prices of items on the store ex-tax, but I still need to show the inc-tax amount on the invoice. If I set Display Prices with Tax to false, the invoice shows Price(ex) as the samle as Price(inc) and Total(ex) the same as Total(inc)... In admin/invoice.php the inc tax amount is calculated using tep_add_tax. In the definition of tep_add_tax in includes/functions/general.php, it only functions if DISPLAY_PRICE_WITH_TAX == true Can you suggest another way of doing this so that I can still show inc tax amounts on the invoice even if my store prices are shown ex tax ?? Cheers, Paul.
  15. PaulOB

    Multi_Vendor_Shipping new thread

    Hi Jim / Craig, I don't know if this has anything to do with MVS, or if it's just my setup with its peculiarities and lack of register globals... Anyway the problem I'm having concerns tax: If I set Display Prices with Tax in admin to false it seems to cause these problems: - Price(inc) and Total(inc) on the invoice (viewed from admin -> customers -> orders) are the same as Price(ex) and Total(ex), yet Sub-total: and Total: correctly show the price including tax - At checkout_confirmation it does not show tax (only Sub-Total, Shipping & Total), yet the Total amount correctly shows the amount including tax. I've spent almost an entire day trying to track down the source of this error and need help! Thanks again, Paul.
×