[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?

 

Find

if (action == 'subtotal') {
 <?php if (DISPLAY_PRICE_WITH_TAX == 'true') { ?>
 if(pid == 'p-total_incl')// display price with tax => total including tax
 <?php } else { ?>
 if(pid == 'p-total_excl')// display price without tax => total excluding tax
 <?php } ?>
 {
 sum+=Number(el[i].value);
 }
 }

 

and change it to

if (action == 'subtotal') {
 <?php if (DISPLAY_PRICE_WITH_TAX == 'true') { ?>
 if ((pid == 'p-total_incl') || (pid == 'ot_coupon'))// display price with tax => total including tax
 <?php } else { ?>
 if((pid == 'p-total_excl') || (pid == 'ot_coupon'))// display price without tax => total excluding tax
 <?php } ?>
 {
 sum+=Number(el[i].value);
 }
 }

 

Then find

if (action =='total'){
//I cheat here- the grand total always includes the value of the various totals including tax of 
//each item, regardless of individual shop settings.  So I take the various Total incls, all the
//ot_customs, ot_loworderfees, and any ot_shipping value, and voila
if ((pid ==  'ot_custom') || (pid == defaultTaxName + 'ot_shipping') || (pid == 'p-total_incl') || (pid == 'ot_loworderfee')) {
sum += Number(el[i].value);
 }

 

and change it to

if (action =='total'){
//I cheat here- the grand total always includes the value of the various totals including tax of 
//each item, regardless of individual shop settings.  So I take the various Total incls, all the
//ot_customs, ot_loworderfees, and any ot_shipping value, and voila
if ((pid ==  'ot_custom') || (pid == defaultTaxName + 'ot_shipping') || (pid == 'p-total_incl') || (pid == 'ot_loworderfee') || (pid == 'ot_coupon')) {
sum += Number(el[i].value);
 }

 

Let me know how this goes. You may need additional custom code to get the tax totals right.

[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?

[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?

[NEW! Complete Order Editing Tool!]

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

[NEW! Complete Order Editing Tool!]

Sweeeeet. That was a great reply.

[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.

[Authorize.net error when trying to relay response to page in protected folder?]

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.

[Authorize.net, Changing total price before Capturing]

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!

[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.

[QBI Quickbooks Import]

Are you referring to Customer information that is over-written when a customer makes a second order?

 

I'm not quite following. There are "Custom Fields" in QB for items that you could use for the UPS, and then configure your Invoice template to show them as a column on your invoices.

 

No, you can't.

 

Thanks,

Adam

 

 

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.

[QBI Quickbooks Import]

This capability and the tables needed are already built into QBI. You need to do the Set Up:Products and Match:Products procedure to make a correspondence in QBI between Child009 in osC and Parent009:Child009 in QB. See the details on how to do this in the instruction manual.

 

Thanks,

Adam

 

 

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.

[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?

["All Products Page" Slight Change to way Populated]

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