Jump to content

longlam

Members
  • Content count

    27
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Long Lam
  1. longlam

    NEW! Complete Order Editing Tool!

    You were right about the taxes being off. It looks like it is getting the total tax from the products. What I would like to do is somehow get it from the subtotal minus the discount. Any ideas how we can make that happen?
  2. longlam

    Seperate Pricing Per Customer v3.5

    Is it possible to set up a blanket price for certain customers that is a percentage off? Currently we have everything set up but would like an easy way to update our 2000 products for the two different types of customers that we have as well as when we use easypopulate to import new customers it seems like we will have to edit the script to also create these new rows in the new pricing table?
  3. longlam

    Seperate Pricing Per Customer v3.5

    Real quick question before I dive into installation of this beast, we can set a percentage discount that will apply across all products as well as specific product based pricing correct? So for group A, I want to be able to apply a 50% across all products, but for a few products I will go in and make it 40% off. This is what the mod can handle correct?
  4. longlam

    NEW! Complete Order Editing Tool!

    Also, where would we adjust the javascript to reflect these changes?
  5. longlam

    NEW! Complete Order Editing Tool!

    Sweeeeet. That was a great reply.
  6. longlam

    NEW! Complete Order Editing Tool!

    Hello, I have been using the order editor and ran into the bug. I have been looking through this discussion and have yet to find the answer. What we want is for the discount coupon to apply to the subtotal and then have the tax be calculated on the discounted subtotal. I know this would be an issue because after looking at how tax is tracked at the item per item level rather then at the subtotal level this would be an issue. So i tried to parse out the code that would allow me to just do discount * tax percent - subtotal to get the right subtotal that we need but couldn't figure out where you were calculating the discount into the order total. Since we use the same tax percent for all the items there won't be an issue finding which tax percent to use but I just need to know where you guys evalute the "ot-coupon" class so that I can adjust the running total to this new amount. Thanks in advance.
  7. Hello, I am trying to set up a relay response using the SIM mode. I get an authorization error and I am guessing that it is because the response page that I am redirecting to is in a protected folder that requires a username/password to get into it, ie the admin area. Can you please confirm if this is the reason for the error and if it is how can I work around it? Thanks.
  8. Hello OsCommerce Community, What we want to do is authorize the credit card before shipping, then go into in the admin in authorize.net and capture. The only tricky thing is I was wondering if there was a way to change the amount to be captured if for instance we were going to shortship and then ship the other products later. Is there an easy way to do this in authorize.net? Thanks!
  9. longlam

    QBI Quickbooks Import

    Now that i have the this up and running i was wondering if you guys had a solution about importing the iif file without admin access. I want to have the guys in the warehouse be able to upload the iif file without needed to switch to single user or to the admin name. If you guys have a solution for this it would be much appreciated.
  10. longlam

    QBI Quickbooks Import

    In terms of the customer information, it is additional information that I have in quickbooks such as price levels that seems to be overwritten when I import from the iif file. Basically what quickbooks seems to be doing is instead of matching the customer, it overwrites it. What I'm trying to do is that I have repeat customers from the website and I don't want to re-establish all the other special fields I have for them after I import. In terms of the UPC, yes I forgot it is a custom field, I remember seeing somewhere a CUSTFLD1, can I tag that to the end of the transaction line and have it input it into quickbooks as a UPC? In reply to the other fellows question, you need to set your check and money order to prepaid and then it will import as a sales receipt. To make sure you did it right open up your iif file and make sure it says CASH SALE instead of INVOICE in the transaction lines.
  11. longlam

    QBI Quickbooks Import

    THanks for the reply adam. The only problem was that I had to match up 1000 products. In the end I found a work around in the matching system where I would do a match with the SKU's in qbi item table lookup instead of the matching table. It saved me hours believe me. The last few things that I have to work out are: Company Information being overwritten when importing. There are fields such as price levels that I don't want to be overwritten. My go around rite now is importing as temp and then changing the customer. UPC codes. When invoicing to wholesalers the UPC field is necessary. Right now there is no UPC field built into OSCommerce that I can work with. My thoughts are to build in a new field in the product table, tell easy populate to populate that field with my given upc's and then have quickbooks pull that upc into the right field. Does anyone know what the UPC field name might be so that I can import into quickbooks? On the same note is there anyway to export an invoice from quickbooks into a iif file. From what I've read and found, the answer is no.
  12. longlam

    QBI Quickbooks Import

    Hello All, I've run into a problem matching up my oscommerce products with those in quickbooks. In oscommerce I have only the child upc so for instance Child009 but in quickbooks it is listed as Parent009:Child009. When I download the order the products don't match because the two SKU's aren't the same. I've looked at the php and it seems like I can circumvent if I was able to do a table lookup that could match a substring from the qbi items table with the product id in the qbi engine order file but i'm unsure if you can even do that with sql. Do you guys know of a better solution?
  13. Right now I have set up the all products page to work but it populates the page a little weird. It does everything right but I have Parent categories not being listed on after the other. Instead it seems like it uses the subcategory number as the means of listing the products. So for example right now it's doing this: Jewelry > Necklaces > ......... ......... Bags > Handbags/Purses > ......... ......... Jewelry > Bracelets/Bangles > ......... ......... but i want the all the jewelry parent categories to go first and so on and so forth. any suggestions? :P
×