Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

gazzzzzza

Members
  • Content count

    266
  • Joined

  • Last visited

1 Follower

Profile Information

Recent Profile Visitors

4,066 profile views
  1. gazzzzzza

    Session is lost after callback from credit card processor

    when you do the link to and from your page, use the functionb tep_href_link which is stored in includes/functions/html_output.php by default, it will then have the id passed back and forward.
  2. gazzzzzza

    Previous Next Links from image to text

    Apologies for the code not working. I have not used Ultimate SEO so cannot really comment on that. All i changed on the code you gave me was the actual operator, (the image that you click). I just replaced them with text instead - e.g. <?php echo tep_image_button('button_prev.gif', IMAGE_BUTTON_PREVIOUS); ?> became NEW TEXT I cannot see where the problem is as the link will not have been changed, just the thing that you click has been changed.
  3. gazzzzzza

    Previous Next Links from image to text

    Heres a quick fix for you Beth <tr> <td align="center" class="main"><a href="<? echo tep_href_link(FILENAME_PRODUCT_INFO, "products_id=$previous&cPath=$cPath"); ?>"> <?php echo "PUT YOUR LINK TEXT FOR PREVIOUS HERE"; ?> </a></td> <!-- <td align="center" class="main"><?php echo (PREV_NEXT_PRODUCT); ?> <?php echo ($position+1 . "/" . $counter); ?><br><?php echo (PREV_NEXT_FROM) ?> <?php echo ($category_name_row['categories_name']); ?></td> --> <td align="center" class="main"> <?php echo ($position+1 . " of " . $counter); ?></td> <td align="center" class="main"><a href="<? echo tep_href_link(FILENAME_PRODUCT_INFO, "products_id=$next_item&cPath=$cPath"); ?>"> <?php echo "PUT YOUR LINK TEXT FOR NEXT HERE"; ?> </a></td> </tr> think that should be it
  4. gazzzzzza

    QBI Quickbooks Import

    the command is Alter table orders add column (qbi_imported int not null default 0); if you want null to be left the obviosuly do not insert the 'not null' bit
  5. gazzzzzza

    QBI Quickbooks Import

    I already spoke to intuit about XML. Guess what...they are not releasing the Quickbooks version with XML support in the UK. Bunch of muppets. They are debating whether it would be worth releasing it and if they do it is likely to be next year. How ridiculous! So we get stuck with IIF. I found another contribution which exports to allow input using XML but it is for the canadian version unfortunately, thats what lead me to contact Intuit about XML. O and we cannot import a foreign version either cos the tax is all setup differently. Great huh :angry: Has anyone heard from Adam about a likely release date for the next version of this contribution? It sounds like it will be just the job! You are right about a well deserved holiday though-I can't believe he is still replying to these posts after 30 odds pages of posting!
  6. gazzzzzza

    QBI Quickbooks Import

    Wow thanks for the info. Doesn't look promising does it :'( Any chance we could use that code you just posted (the IIF examples) and possibly modify the tax exporter bit to write the UK 'style' IIF instead of the USA one (just for the tax part of the IIF)? To be honest I do not really understand Quickbooks myself but I'm not bad with PHP so maybe if I could actually understand what needs to be worked out/outputted from where then I could do this (with your help of course!). The other option I guess would be to not include tax? But would that error also because some of my totals from the shop would contain VAT? Or would it just ignore the VAT and continue on happily? Alternatively, does anyone know of a program that OSC orders can be imported into successfully? In England ;) That is not going to break the bank.... and cool your from Hull volumax - I'm living in Scarboro...small world isn't it
  7. gazzzzzza

    QBI Quickbooks Import

    Cheers for the reply djs I began working with Quickbooks Pro 2001 :D But now I am working with QuickBooks Pro Edition 2004. I am based in England so it may be a slightly different version but I cannot imagine they would differ that much??! Do you guys have knowledge of that? The tax rate in England is always 17.5% but this is merely a number I thought. Surely this could be different for each user? It is programmed into the database so why should it make a difference? Surely the equations are the same, but with a different number within the equation? Any suggestions on what I can change? I think I have tried pretty much all of the available options through the contribution admin panel with no success. I'm open to trying most things! :blink:
  8. gazzzzzza

    QBI Quickbooks Import

    I've noticed mine is really messed up now. Not sure how or why but I am getting the following error also for some of the imported orders (I had not noticed it before but I am guessing it was there all along): You cannot associate an item with VAT control, undeposited funds, accounts receivable, accounts payable, non-posting accounts, or suspense accounts. Usually, if you sell the item, use an income account; if you buy it, use an expense account. I have only modified the settings in the export options on the 'Quickbooks Contribution' (in a lame attempt to fix the transaction in balance error!) :'( I have tried getting a log of the orders export but this is not helping me figure out what is wrong. The log of my setup is posted below: along with one of the identical orders from above that I have exported. (The first order seems to give the 'transaction in balance', and the second one gives the other error) I could really use some assistance on this because I am getting nowhere fast. I need to get this working by Thursday at the latest and my head feels like it is going to explode from looking at errors non stop for weeks now!! Hope someone can help, any assistance will be gratefully received. Export Log: Quickbooks Import QBI Error Log QBI Version: 2.10 Date/Time: Aug 15, 2005 11:23:48 AM Default Language Name: en Default Language ID: 1 Configuration: QBI Quickbooks version: 2003 Download iif: 1 Product rows dispayed: 5 Products dropdown sort order: 0 Products dropdown width: 48 Products dropdown width: 1 Orders Import orders with status: 0 Update status: 0 Change CC order status to: 1 Change check/mo status to: 1 Send status email: 0 Delete credit card number: 0 Customers Customer number (business): %L50W, %F50W - %I Customer number (residence): %L50W, %F50W - %I Customer limit: 0 Customer type: Use state codes: 0 Include local country: 0 Include company and contact: 1 Invoices Invoice account: Accounts Receivable Sales Receipt account: Undeposited Funds Invoice number: %I Invoice/Sales Receipt 'PO Number': %I Invoice to print: 1 Invoice terms paid online: Invoice terms not prepaid: Invoice rep: Invoice fob: Include customer comments: 1 Customer message: Invoice memo: Items Item income account: Cost of Goods Sold Item asset account: Inventory Asset Item class: COGS account: Cost of Goods Sold Description language: 0 Match inventory: 1 Match non-inventory: 0 Match services: 0 Use default item: 0 Default name: Import type: 0 Shipping Shipping name: Flat Rate Shipping Shipping description: Flat Rate Shipping Shipping account: Shipping Cost Shipping class: Flat Rate Shipping Shipping taxable: 1 Taxes Tax turned on: 1 Tax name: Taxable Goods Tax agency: Government Tax rate: 17.5 Use tax name table: 0 Payments Import payments: 0 Payment memo: Same two examples as previous posts: !CUST NAME BADDR1 BADDR2 BADDR3 BADDR4 BADDR5 SADDR1 SADDR2 SADDR3 SADDR4 SADDR5 PHONE1 PHONE2 FAXNUM EMAIL NOTE CONT1 CONT2 CTYPE TERMS TAXABLE TAXITEM LIMIT RESALENUM REP COMPANYNAME SALUTATION FIRSTNAME LASTNAME CUST Bloggs, Joe - 14 Joe Bloggs Flat 4 Scarborough North Yorkshire YO11 2EZ Joe Bloggs Flat 4 Scarborough North Yorkshire YO11 2EZ Joe Bloggs Y Taxable Goods Joe Bloggs !TRNS TRNSID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR TOPRINT ADDR1 ADDR2 ADDR3 ADDR4 ADDR5 SADDR1 SADDR2 SADDR3 SADDR4 SADDR5 NAMEISTAXABLE TERMS SHIPVIA REP FOB INVMEMO PAYMETH PONUM !SPL SPLID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR QNTY PRICE INVITEM TAXABLE PAYMETHOD EXTRA !ENDTRNS TRNS INVOICE 09/29/2004 Accounts Receivable Bloggs, Joe - 14 97.85 121 N Y Joe Bloggs Flat 4 Scarborough North Yorkshire YO11 2EZ Joe Bloggs Flat 4 Scarborough North Yorkshire YO11 2EZ Y Method not set 121 SPL INVOICE 09/29/2004 Cost of Goods Sold -37.45 AQ2 Aquapuretraveller - (with iodine filter) N -1 37.45 131 Y SPL INVOICE 09/29/2004 Cost of Goods Sold -21.06 Expedition Barrel with locking top band N -2 10.53 124 Y SPL INVOICE 09/29/2004 Cost of Goods Sold -3.84 Go Electrolyte (Hydration) Blackcurrant N -3 1.28 77 Y SPL INVOICE 09/29/2004 Cost of Goods Sold -2.5 APPLE WITH CUSTARD N -1 2.5 72 N SPL INVOICE 09/29/2004 Cost of Goods Sold -6.9 BACON AND BEANS N -2 3.45 10 N SPL INVOICE 09/29/2004 Cost of Goods Sold -10.35 BEANS AND SAUSAGE N -3 3.45 9 N SPL INVOICE 09/29/2004 N SPL INVOICE 09/29/2004 Shipping Cost Flat Rate Shipping -4.13 Flat Rate Shipping N -1 4.1300 Flat Rate Shipping Y SPL INVOICE 09/29/2004 Sales Tax Payable Government -11.63 N 17.5% Taxable Goods N AUTOSTAX ENDTRNS !CUST NAME BADDR1 BADDR2 BADDR3 BADDR4 BADDR5 SADDR1 SADDR2 SADDR3 SADDR4 SADDR5 PHONE1 PHONE2 FAXNUM EMAIL NOTE CONT1 CONT2 CTYPE TERMS TAXABLE TAXITEM LIMIT RESALENUM REP COMPANYNAME SALUTATION FIRSTNAME LASTNAME CUST Bloggs, Joe - 14 Joe Bloggs Flat 4 Scarborough North Yorkshire YO11 2EZ Joe Bloggs Flat 4 Scarborough North Yorkshire YO11 2EZ joe@save9.com Joe Bloggs Y Taxable Goods Joe Bloggs !TRNS TRNSID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR TOPRINT ADDR1 ADDR2 ADDR3 ADDR4 ADDR5 SADDR1 SADDR2 SADDR3 SADDR4 SADDR5 NAMEISTAXABLE TERMS SHIPVIA REP FOB INVMEMO PAYMETH PONUM !SPL SPLID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR QNTY PRICE INVITEM TAXABLE PAYMETHOD EXTRA !ENDTRNS TRNS INVOICE 09/29/2004 Accounts Receivable Bloggs, Joe - 14 92.86 122 N Y Joe Bloggs Flat 4 Scarborough North Yorkshire YO11 2EZ Joe Bloggs Flat 4 Scarborough North Yorkshire YO11 2EZ Y Method not set 122 SPL INVOICE 09/29/2004 Cost of Goods Sold -74.9 AQ2 Aquapuretraveller - (with iodine filter) N -2 37.45 131 Y SPL INVOICE 09/29/2004 N SPL INVOICE 09/29/2004 Shipping Cost Flat Rate Shipping -4.13 Flat Rate Shipping N -1 4.1300 Flat Rate Shipping Y SPL INVOICE 09/29/2004 Sales Tax Payable Government -13.83 N 17.5% Taxable Goods N AUTOSTAX ENDTRNS
  9. gazzzzzza

    QBI Quickbooks Import

    Adam - thanks for the suggestion of the sales rounding fix. I have implemented that but am still getting the same errors with every transaction not being in balance. Will the fact that we sell in ? be causing problems? OR, could it be that the shipping cost appears to be in the wrong format??? e.g. (note the 4.1300??) SPL INVOICE 09/29/2004 Shipping Cost Flat Rate Shipping -4.13 Flat Rate Shipping N -1 4.1300 Flat Rate Shipping Y here are two example failures. (one is the same as on my previous post but obviously the sales rounding fix has taken effect hence the difference). !CUST NAME BADDR1 BADDR2 BADDR3 SADDR1 SADDR2 SADDR3 PHONE1 PHONE2 FAXNUM EMAIL NOTE CONT1 CONT2 CTYPE TERMS TAXABLE TAXITEM LIMIT RESALENUM REP COMPANYNAME SALUTATION FIRSTNAME LASTNAME CUST Bloggs, Joe - 14 Joe Bloggs Flat 4 Scarborough North Yorkshire YO11 2EZ Joe Bloggs Flat 4 Scarborough North Yorkshire YO11 2EZ Joe Bloggs Y Taxable Goods Joe Bloggs !TRNS TRNSID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR TOPRINT ADDR1 ADDR2 ADDR3 ADDR4 ADDR5 SADDR1 SADDR2 SADDR3 SADDR4 SADDR5 NAMEISTAXABLE TERMS SHIPVIA REP FOB INVMEMO PAYMETH PONUM !SPL SPLID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR QNTY PRICE INVITEM TAXABLE PAYMETHOD EXTRA !ENDTRNS TRNS INVOICE 09/29/2004 Accounts Receivable Bloggs, Joe - 14 97.85 121 N Y Joe Bloggs Flat 4 Scarborough North Yorkshire YO11 2EZ Joe Bloggs Flat 4 Scarborough North Yorkshire YO11 2EZ Y Method not set 121 SPL INVOICE 09/29/2004 Cost of Goods Sold -37.45 AQ2 Aquapuretraveller - (with iodine filter) N -1 37.45 131 Y SPL INVOICE 09/29/2004 Cost of Goods Sold -21.06 Expedition Barrel with locking top band N -2 10.53 124 Y SPL INVOICE 09/29/2004 Cost of Goods Sold -3.84 Go Electrolyte (Hydration) Blackcurrant N -3 1.28 77 Y SPL INVOICE 09/29/2004 Cost of Goods Sold -2.5 APPLE WITH CUSTARD N -1 2.5 72 N SPL INVOICE 09/29/2004 Cost of Goods Sold -6.9 BACON AND BEANS N -2 3.45 10 N SPL INVOICE 09/29/2004 Cost of Goods Sold -10.35 BEANS AND SAUSAGE N -3 3.45 9 N SPL INVOICE 09/29/2004 N SPL INVOICE 09/29/2004 Shipping Cost Flat Rate Shipping -4.13 Flat Rate Shipping N -1 4.1300 Flat Rate Shipping Y SPL INVOICE 09/29/2004 Sales Tax Payable Government -11.63 N 17.5% Taxable Goods N AUTOSTAX ENDTRNS !CUST NAME BADDR1 BADDR2 BADDR3 SADDR1 SADDR2 SADDR3 PHONE1 PHONE2 FAXNUM EMAIL NOTE CONT1 CONT2 CTYPE TERMS TAXABLE TAXITEM LIMIT RESALENUM REP COMPANYNAME SALUTATION FIRSTNAME LASTNAME CUST Bloggs, Joe - 14 Joe Bloggs Flat 4 Scarborough North Yorkshire YO11 2EZ Joe Bloggs Flat 4 Scarborough North Yorkshire YO11 2EZ joe@save9.com Joe Bloggs Y Taxable Goods Joe Bloggs !TRNS TRNSID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR TOPRINT ADDR1 ADDR2 ADDR3 ADDR4 ADDR5 SADDR1 SADDR2 SADDR3 SADDR4 SADDR5 NAMEISTAXABLE TERMS SHIPVIA REP FOB INVMEMO PAYMETH PONUM !SPL SPLID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR QNTY PRICE INVITEM TAXABLE PAYMETHOD EXTRA !ENDTRNS TRNS INVOICE 09/29/2004 Accounts Receivable Bloggs, Joe - 14 92.86 122 N Y Joe Bloggs Flat 4 Scarborough North Yorkshire YO11 2EZ Joe Bloggs Flat 4 Scarborough North Yorkshire YO11 2EZ Y Method not set 122 SPL INVOICE 09/29/2004 Cost of Goods Sold -74.9 AQ2 Aquapuretraveller - (with iodine filter) N -2 37.45 131 Y SPL INVOICE 09/29/2004 N SPL INVOICE 09/29/2004 Shipping Cost Flat Rate Shipping -4.13 Flat Rate Shipping N -1 4.1300 Flat Rate Shipping Y SPL INVOICE 09/29/2004 Sales Tax Payable Government -13.83 N 17.5% Taxable Goods N AUTOSTAX ENDTRNS I hope we can get that extra 1% working!!
  10. gazzzzzza

    QBI Quickbooks Import

    Hi I am so close to getting this working. The export runs OK but when I import the files, I get the following error: 'The transcation is not in balance. Make sure the amounts in the detail area on the form equal the amount at the top of the form.' Below is one of the transactions that seems to be causing issues. Does anyone know how to fix this problem? It seems to import some of the transactions but not others. Or maybe it is just importing the customers, I am not much good at Quickbooks yet so I haven't figured it out! !CUST NAME BADDR1 BADDR2 BADDR3 SADDR1 SADDR2 SADDR3 PHONE1 PHONE2 FAXNUM EMAIL NOTE CONT1 CONT2 CTYPE TERMS TAXABLE TAXITEM LIMIT RESALENUM REP COMPANYNAME SALUTATION FIRSTNAME LASTNAME CUST Bloggs, Joe - 14 Joe Bloggs Flat 4 Scarborough North Yorkshire YO11 2EZ Joe Bloggs Flat 4 Scarborough North Yorkshire YO11 2EZ Joe Bloggs Y Taxable Goods Joe Bloggs !TRNS TRNSID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR TOPRINT ADDR1 ADDR2 ADDR3 ADDR4 ADDR5 SADDR1 SADDR2 SADDR3 SADDR4 SADDR5 NAMEISTAXABLE TERMS SHIPVIA REP FOB INVMEMO PAYMETH PONUM !SPL SPLID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR QNTY PRICE INVITEM TAXABLE PAYMETHOD EXTRA !ENDTRNS TRNS INVOICE 09/29/2004 Accounts Receivable Bloggs, Joe - 14 97.85 121 N Y Joe Bloggs Flat 4 Scarborough North Yorkshire YO11 2EZ Joe Bloggs Flat 4 Scarborough North Yorkshire YO11 2EZ Y Method not set 121 SPL INVOICE 09/29/2004 Cost of Goods Sold -37.45 AQ2 Aquapuretraveller - (with iodine filter) N -1 37.45 131 Y SPL INVOICE 09/29/2004 Cost of Goods Sold -21.06 Expedition Barrel with locking top band N -2 10.53 124 Y SPL INVOICE 09/29/2004 Cost of Goods Sold -3.84 Go Electrolyte (Hydration) Blackcurrant N -3 1.28 77 Y SPL INVOICE 09/29/2004 Cost of Goods Sold -2.5 APPLE WITH CUSTARD N -1 2.5 72 N SPL INVOICE 09/29/2004 Cost of Goods Sold -6.9 BACON AND BEANS N -2 3.45 10 N SPL INVOICE 09/29/2004 Cost of Goods Sold -10.35 BEANS AND SAUSAGE N -3 3.45 9 N SPL INVOICE 09/29/2004 N SPL INVOICE 09/29/2004 Shipping Cost Flat Rate Shipping -4.13 Flat Rate Shipping N -1 4.1300 Flat Rate Shipping Y SPL INVOICE 09/29/2004 Sales Tax Payable Government -11.63 N 17.5% Taxable Goods N AUTOSTAX ENDTRNS Any help will be greatly appreciated - I really want to get this contribution working 100% - it will be sooo useful :D
  11. gazzzzzza

    QBI Quickbooks Import

    Hi I really want to give this contribution a go but I cannot find the files to download! Where can I get them?? I have visited http://www.oscommerce.com/community/contributions,2847 but there does not appear to be a link to download the files?? Any ideas why this is? Or am I just being very stupid?? Scratch that-I found it. Sorry for the stupid message! I'll post how I get on with the contrib.
  12. gazzzzzza

    credit card number problem

    just had a complaint that a mastercard was not accepted. guess the original verification for mcard isnt perfect after all!
  13. I use the UK switch contribution which allows you to select which cards you want to accept. There have been a few probs with certain card numbers though. Mastercard is the main one that people have said that it wouldnt accept. But give it a go.
  14. gazzzzzza

    QBI Quickbooks Import

    Adam This looks like a fantastic contribution and hopefully will be very useful to me as Quickbooks severely confuses me!! It certainly seems to be popular amongst the community :D I have a problem with making use of the contribution though. I have built a new admin area to use for clients OSC based websites as the old one offered too many dangerous options for a regular admin user of the site to use and I felt that it would be easier to add new site admin functionality through my own admin area for things not linked to OSC and even some functionality that is. This is where my first problem occurs. Using your contribution is not really an ideal solution for me as it involves using the old default OSC admin panel. I would like to make use of your functionality and modify it to fit my admin panel if possible. I have built an export of orders which exports the data as either a CSV or an XLS file. My problem is that I do not know enough about quickbooks to know how to import the details correctly. Would it be possible for you to provide me with the column names etc that you use so I can layout my data correctly for the import? I have installed your contribution onto the original OSC admin panel but when I try to import I get the same error as alot of people. (Transaction is not in balance ...) I have tried setting tax to be the same in both QBI and QB and tried exporting and importing with tax off but I cannot get it to work. The initial site I am testing on uses tax at 17.5% and the tax class is called 'Taxable Goods' in OSC. THe client sells some items which require tax and some which do not - these have a tax class of Non-Taxable. Do you have any ideas on where I need to setup tax things and what I should set up within both QB + QBI? I have also had trouble inporting the product list. This may be due to the fact I have modified the OSC products to include extra data like carbohydrates, calories etc etc. (THese are all added through the product adding function in my admin area). Do you think this will affect your contribution and make it so that I cannot get it to work? I do not get any error messages but cannot find the products anywhere within QB. This may be down to my limited knowledge of the program though!! I managed to get the customers to import into QB and I have also modified the tables relating to them by adding extra fields. This makes me think that maybe this is not the issue with my failure importing products. Basically, I would be grateful for any help on any of the above issues as quickbooks is proving to be a bit of a nightmare for me. I am just a programmer not an accountant and have no experience with the program :blink: And I noticed one person waaaay back on page 5 of this topic was asking about using offline orders with OCS. I built functionality to allow people to add orders through the admin console aswell as add users etc. This enables my client to put all of his orders through OSC. I'm sure programmers with the skills on show here would be able to replicate similar functionality into the original OSC admin. This would be a very useful conribution I believe. The only problem with the idea is that people who order offline do not always have email addresses so signing them up for an account is not easy unless you modify OSC to use usernames instead of email addresses for the login etc. Obviously they cannot purchase via OSC without an email address but it does allow you to get them into the system. Unfortunatley, I have not made a single modification to the default OSC admin and do not know my way around the code at all so I am not currently able to build this contribution :( It took me months to figure out the front end so I could modify it at all !! anyways - sure i've taken up enough of everyones time. Cheers Gareth
  15. gazzzzzza

    credit card number problem

    The original OSC MASTERCARD verification does work, it was the verification that came with the SWITCH contribution that was broken. If you use this contrib then check 'USE ORIGINAL MASTERCARD VERIFICATION' instead of the new verification.
×