Jump to content

mpiscopo

Members
  • Content count

    399
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by mpiscopo

  1. This is a new contribution for integrating QuickBooks with osCommerce. This contribution makes integration with QuickBooks easy as there is no manual matching of inventory products in osCommerce and has some other features I needed. Features Include: 1) Completely Automated matching of products between QuickBooks and osCommerce (no need to manually match products - handles matching products in osCommerce with products which are in categories in QuickBooks). Products are matched according to Product Model (osCommerce) and Item Name/Number (QuickBooks). 2) Updates inventory quantities in osCommerce with quantities from QuickBooks (option not to update included). This ensures that QuickBooks is the master inventory record and allows you to sell from multiple websites and keep inventory quantities updated on all sites. 3) Imports orders into QuickBooks, creates account in QuickBooks if it doesn't exist. 4) Options for different account naming formats when creating new accounts in QuickBooks (6 options). 5) Sales tax configuration option. 6) Invoice Memo configuration option (custom memo such as Thank You for Shopping Acme Products). 7) Log file retention time is configurable. 8) Ability to update values from Custom Fields in QuickBooks to product values in osCommerce. Contribution Link: http://addons.oscommerce.com/info/5803
  2. mpiscopo

    Linkpoint API Problems

    I've been using this API for a long time; however, Discover cards have never worked. The user gets the following message when using a Discover card: "SGS-002000: The server encountered an error: Unsupported credit card type.” Has anyone experienced this problem? Thanks, Mark
  3. mpiscopo

    EZ QuickBooks Integration Contribution

    QuickBooks Professional is fine for single user instances. I use Enterprise version because I have multiple people accessing QuickBooks at the same time. That's pretty much the difference between the two versions.
  4. mpiscopo

    EZ QuickBooks Integration Contribution

    QuickBooks and MYOB are structured differently; it won't work with MYOB. I haven't used MYOB in years, so I'm not knowledgable with the import and export features of it. I switched from MYOB to QuickBooks about 5 years ago because there was so little support for MYOB (technical integration along with accountants and bookkeepers). You might want to consider the pros and cons of migrating...
  5. mpiscopo

    EZ QuickBooks Integration Contribution

    The automatic matching of QBI only works if you don't use categories in QuickBooks. If you have your products categorized in QuickBooks then the part number you import needs to include the category name as a part of the number. Therefore, I had to manually match all my products in QBI. I paid Adam for use of his QBI and it served me well, but eventually I had to hire a programmer to create a new version which removed the manual matching of products. In the spirit of true open source, I had the programmer package it as a contribution and made it available for others to make use of as they need - free of charge. Mark
  6. mpiscopo

    EZ QuickBooks Integration Contribution

    Paul, I looked at the iif file you sent. You have bold tags in the order total field. Open the file with excel and you'll see the <b> and </b> tags. Check your database to see if the tags are in the database or whether you're inserting them in your PHP code. Mark
  7. mpiscopo

    EZ QuickBooks Integration Contribution

    Lynn, It looks like you're missing the items in the export file - everything else seems to be there. I'll look at it closer today. Did you doublecheck your log files to see that the import matched products in QB to those items?
  8. mpiscopo

    EZ QuickBooks Integration Contribution

    Hi Lynn, 1) I don't know how the Inventory Assemblies works, so I can't answer that. 2) No, it doesn't work with product attributes as I don't use this in osCommerce and am not familiar the use of that feature. 3) Does each unique piece of artwork have its own part number? If so, then it's the same as any other inventory item and should work. The programmer who created this contribution for me is in this forum (Bogdan) and can be hired to add other features. He does a great job and is very reasonable in his pricing. Many of these features I don't use so I really can't work with him on them - since I wouldn't be able to define the requirements accurately and test the resulting program. Mark
  9. mpiscopo

    EZ QuickBooks Integration Contribution

    Jesse, Did you figure this out? If not, send me a copy of your export file so I can look at it. You can also look at your export files to see if the transactions are in them - or if there's a problem. Open it with Excell and you'll be able to see the customer information and the order information. Mark
  10. mpiscopo

    EZ QuickBooks Integration Contribution

    You can try opening the file with Excel then saving it as a tab delimited file. The IIF file QuickBooks creates is tab delimited.
  11. mpiscopo

    EZ QuickBooks Integration Contribution

    You really should be matching part numbers as they are unique. I don't believe you can import a qbi file into QuickBookswithout part numbers - OB won't allow that.
  12. mpiscopo

    EZ QuickBooks Integration Contribution

    I'm using it with QuickBooks Enterprise Solutions 7.0. There are no changes in the import/export files between 7.0 and 8.0, so it should work fine.
  13. mpiscopo

    EZ QuickBooks Integration Contribution

    The directory called "code_files" is the name of the directory which holds the files with the php progamming code. Under that directory there is an admin directory - that admin directory matches the admin directory under your /catalog/admin. Just copy the /code_files/admin directory to /catalog/admin.
  14. mpiscopo

    EZ QuickBooks Integration Contribution

    I just read that the QBI contribution isn't compatible with QuickBooks POS. If so, then this one probably isn't either as they both create pretty much the same import file for orders. If you know what the differences are, then I'm pretty sure the changes should be pretty easy.
  15. mpiscopo

    EZ QuickBooks Integration Contribution

    Well, that's a unique twist. As it is, it'll update your quantities in QuickBooks for all the products you have in the order. If there is a product in the order which doesn't exist in QuickBooks, QuickBooks will create that product and subtract the appropriate quantities from inventory. You'll need to customize the contribution for your needs. What you need is a field added to your products table to flag whether to import that product into QuickBooks. But what I don't understand is how you are creating invoices currently. If you have an order which contains both your items and those from another vendor how do you record this in QuickBooks (do you create an invoice only for your products, or do you create one for both - if for both how do you account for their products?). The changes you need are pretty easy if you map your logic out correctly. Do you do your own programming? If not, then you can contact Bogdan - he's the programmer I hired to write this contribution and he can make the changes for you (for a very reasonable fee). He's very good with programming for osCommerce - I use him exclusively for all my changes. Mark
  16. mpiscopo

    EZ QuickBooks Integration Contribution

    Hi Billy, I don't believe it will give you any problems with the database as the fields/tables are unique to this contribution; however, you should always test the installation on a test version of your website (as with all programming/database changes). My site is highly modified and it worked fine. But always Test before going live. I've never used the QuickBooks Point of Sale application. I'm using the Enterprise version of the Manufacturing and Whosale Edition of QuickBooks - this is still QuickBooks core application with some add-ons. I believe that QuickBooks Point of Sale is the same, it's just a version of QuickBooks with the POS add-ons. If so, then it should work flawlessly. But, as with website changes you should make a copy of your QuickBooks database and test against it. Mark
  17. mpiscopo

    EZ QuickBooks Integration Contribution

    I run a cron job to backup my entire database - it works nicely as I've restored my entire site to my development server using that database (nothing was missing). I'm not sure of the contribution name; however, the actual backup file the cron job runs is cron_backup.php. If you can't find it in the contributions, I can email you the file I'm using. This would save you a lot of work in the future should you have a problem with your database.
  18. mpiscopo

    EZ QuickBooks Integration Contribution

    If you use the Froogle exporter you can open the export file in MS Excel and print from there (remove the unwanted columns though). If you don't have that contribution installed I highly recommend that you do and get your products listed in Froogle. It's free and I get sales from there quite often. Otherwise, I don't know of a way to do a quick print of item descriptions and categories.
  19. mpiscopo

    EZ QuickBooks Integration Contribution

    Matthew, The QuickBooks export will not create the products on your website which you have in QuickBooks. This is because there are often many more products in QuickBooks than the website - for instance discontinued items cannot be deleted from QuickBooks as there are transactions against them so QuickBooks just marks them as inactive, but these products will still be in the export file from QuickBooks. What this application does is to match the products in QuickBooks to the same products on your website according to the part number. You'll need to create your products in osCommerce by hand. Or, there is a contribution called easy populate which can import a file into osCommerce for you; however, you'll need to create your import file first (including all the osCommerce properties such as image file, etc). The image name and category ID will not import into QuickBooks with this contribution. You might be able to use the frugal exporter, or similar contribution, to create an export of your products then edit the file to create an IIF to import to QuickBooks. But my real question is why would you want to put image names and osCommerce categories into a custom field in QuickBooks? I don't see that it would be beneficial. You can organize your products in QuickBooks by putting them into categories and subcategories, but this is independent of osCommerce as you can have products in multiple categories in osCommerce. Mark
  20. mpiscopo

    EZ QuickBooks Integration Contribution

    Michael, The tax item should match what you have in QuickBooks. For instance, I charge sales tax for the state of Maryland so I have "Comptroller of Maryland - SUT" in the TaxItemDescription field. Let me know if this works for you.
  21. mpiscopo

    EZ QuickBooks Integration Contribution

    The integration is based on QuickBooks IIF files so it should work fine unless there is a difference in IIF file field names in the Australian version - however, I would think these are the same. You would want to try it on a development version of your website first - which is standard practice for installing any osCommerce contributions (or least should be if you don't). As far as osCommerce versions, I'm using both v2.2 RC1 and an older version I installed years ago (I believe it's 1.4). Mark
  22. mpiscopo

    EZ QuickBooks Integration Contribution

    Hi Andrea, The biggest difference is that you don't need to manually match the products within osCommerce. Adams version is very good and I used it for years; however, my store had grown and doing the manual match between the QuickBooks items and osCommerce items was taking a lot of time and was the source of many error as people who were entering the new products were making mistakes in matching. With this version you just upload your items.iif into osCommerce and then osCommerce will automatically match the products based on part numbers - even if you're using categories in QuickBooks (which has always been a pain to match). I also had my programmer add a few options which I needed for my store such as matching custom fields from QuickBooks to a field in osCommerce (I use a custom field in QuickBooks to identify a products location in the warehouse - then osCommerce includes this location in the packing slip). It also updates quantities from QuickBooks to osCommerce as I'm selling from multiple osCommerce stores. Adams version is more mature, so it includes features which this one doesn't. I just had my programmer include the features I needed for my stores. Mark
  23. mpiscopo

    EZ QuickBooks Integration Contribution

    Hi Ethan, There are six options for naming accounts - it works in the same way as the QBI version. 1 - Last Name, First Name 2 - Last Name, First Name and osCommerce Account Number 3 - First Name Last Name 4 - First Name Last Name and osCommerce Account Number 5 - Company Name 6 - Company Name and osCommerce Account Number No, it doesn't handle items with attributes. I haven't used this in my website so I'm not familiar of the functionality. It may be good to add that in a future version. Yes, when you import from osCommerce your QuickBooks inventory is adjusted. No need to sync back unless you have multiple websites selling from the same inventory. For example, if you sell from both your website and Amazon or Ebay you can update your website with new inventory counts after you sell from other stores. I use this option because I have two osCommerce stores selling from the same inventory. Mark
  24. I have many people buying from me who are running a home business, thus they enter a business name for their shipping address. FedEx quotes them the Ground rate, then I get charged later for the difference between Ground and Home. Most other sites I have purchased from ask you if you are shipping to a residential address in the form of a check box. I would much rather do this than have the FedEx contribution make the assumption that since there is a business name that it should be shipped ground. Has anyone addressed this problem for their site? Thanks, Mark
  25. I added a Trade Mark symbol (raised TM) to one of my category pages and to several products pages. Now I'm getting a strange charactor in the URL (?). How can I get rid of this? Is there a place I can put in if the TM symbol is read not to include it in the URL? Here is what the link looks like: http://www.mywebsite.com/giorbello-mosai...s-c-23_155.html Thanks in advance, Mark
×