3242 replies to this topic

[jhilgeman]

We posted at the same time, I think. See my previous comment.

- Jonathan

[chfields]

I am using a mod that randomizes my order numbers. I know nothing about coding. Once I find it how do I change the code? I have to go out for a bit, be back soon.
Thanks in advance

[jhilgeman]

If you'd like, send me a private message and I can help you put in the correct code.

- Jonathan

[jhilgeman]

Okay, a bunch more fixes and additions are here. It's been a busy day for releases and patches.

Version 1.2

- Updated instructions and added some more recommendations.

- Corrected the bug in which the "Billing Address" fields would update the "Customer" fields.

- Added separate "Billing Address" fields, along with compatibility for osC 2.1 (which didn't have separate billing address info)

- Added "Company" and "Suburb" fields to each address section to make them "complete."

- Added ability to add auto-calculated "Tax" entry to the order total.

- Added option for taxing shipping via a variable near the top of the script.

- First (and hopefully last) fix for currency formatting. It used to only calculate using U.S. dollars (how ethno-centric of me...).

- Some additional, but minor bug fixes and corrections.

Feedback, comments, requests, bug reports, etc... are more than welcome.

- Jonathan

[CC]

Sorry I should look into this more, but I thought I would post straight away at finding this error for anyone else who experiences it.

I got this at first attempt at using 1.2:

1064 - You have an error in your SQL syntax near 'comments = '' where orders_id = '100235'' at line 29

[jhilgeman]

Hmmm, line 29 is a bunch of comments. However, line 129 is close to a line that refers to the comments field.

Are you using osC 2.1 by any chance?

Open the file in notepad or your editor, and go to line 124, which should begin with: orders_status = ......

Delete the comma near the end, go down to line 128 (should start with $UpdateOrders), and add the comma right after the first quote and before the word "comments", so it looks like:

$UpdateOrders .= ", comments = '" . tep_db_input($comments) . "'";

Save and upload the file and see if that works. If so, let me know and I'll upload a "1.2b" version with that compatibility fix.

- Jonathan

[jhilgeman]

Also, for anyone who's using a mod that "randomizes" the order ID into a alphanumeric string like AZ12345, here's how to make the mod work (forum member "chfields" just tested it):

Open up the edit_orders.php file and replace all instances of:

(int)$oID

with:

$oID

I probably won't make this a permanent fix. The osC crew put the (int) cast function in there for a reason, so I'll leave it in there, but add instructions to future versions on how to fix the above problem.

- Jonathan

[CC]

Quote

Hmmm, line 29 is a bunch of comments. However, line 129 is close to a line that refers to the comments field.

Are you using osC 2.1 by any chance?

Open the file in notepad or your editor, and go to line 124, which should begin with: orders_status = ......

Delete the comma near the end, go down to line 128 (should start with $UpdateOrders), and add the comma right after the first quote and before the word "comments", so it looks like:

$UpdateOrders .= ", comments = '" . tep_db_input($comments) . "'";

Save and upload the file and see if that works. If so, let me know and I'll upload a "1.2b" version with that compatibility fix.

- Jonathan

Yep, that solved it.

I am now trying to find a way to make this intigrate with P&G Shipping Mod, as I think quite a number of people use it, but this update tool doesnt work with it. The details are not carried forward to the spg_invoice page etc...

[GFW]

n!ce

few bugs @ tax, hope i can explain it with my english....

-) when you click on "edit" you see the product price without tax, but the shipping price is with tax, what happend is that you add the tax twice to the shipping costs!

-) i think nearly everyone in austria/germany uses the "cod_fee_calculation" mod, so there is a extra line for the cod fee added. Same thing for this, you have to add tax to this fee! (This fee is also displayed with tax at the edit screen, but there is nothing added).

What i mean is when you look at the edit module:

Product-Price (w.o. tax)
Shipping (w.o.tax, no it is displayed with tax)
C.O.D Fee (same like shipping)
-----------
Tax
---------
Sum


Added a Screenshot H E R E


Zwischensumme = Sub Total
Versandkosten = Shipping
Nachnahmegebühr = COD Fee
Mehrwertsteuer = Tax

Thx in advance, great mod!

[GFW]

another thing.

wouldnt it be possible to add the tax for every line above the "tax line" ? Because when i deduct a discount the tax is still the same!

[GFW]

triplepost as usual:

would be great if you implement this "flags" mod!

[CC]

Quote

n!ce

few bugs @ tax, hope i can explain it with my english....

-) when you click on "edit" you see the product price without tax, but the shipping price is with tax, what happend is that you add the tax twice to the shipping costs!

-) i think nearly everyone in austria/germany uses the "cod_fee_calculation" mod, so there is a extra line for the cod fee added. Same thing for this, you have to add tax to this fee! (This fee is also displayed with tax at the edit screen, but there is nothing added).

What i mean is when you look at the edit module:

Product-Price (w.o. tax)
Shipping (w.o.tax, no it is displayed with tax)
C.O.D Fee (same like shipping)
-----------
Tax
---------
Sum


Added a Screenshot H E R E


Zwischensumme = Sub Total
Versandkosten = Shipping
Nachnahmegebühr = COD Fee
Mehrwertsteuer = Tax

Thx in advance, great mod!

Hmmm...

I dont follow you there, this is not how it is working for me.

Are you running your store to display prices inc Tax?

All my prices in the edit module are displayed without tax, and then calculated with tax on updating.

[bodyfeelings]

Hallo,

first of all... Thanks for the fast programming of a new release.

Now I have some wishes :

1. :? Is it possible to have a searching for products during you add new products. I have alot of products and it's not very easy to finde them in the dropdownboxes. A search after 'products_name' or better also after 'products_model'

2. :shock: Would be nice to have the possibility to have the functions from edit order status also in edit orders. Not only showing the information.

3. :?: Why you have bild the Adresstables one below the other ?
The release bevore they were side by side. That lokked better.

[GFW]

Quote

Hmmm...

I dont follow you there, this is not how it is working for me.

Are you running your store to display prices inc Tax?

All my prices in the edit module are displayed without tax, and then calculated with tax on updating.

yes, my prices are displayed with tax. litte bit a mess with the tax

- ) when i push the "edit" button, the article price is displayed without tax, the sub-sum with tax. then, when i push the "refresh" button without changing anything, the sub-sum is displayed without tax.

the shipping costs and cod fees are displayed with tax every time, and the shipping cost tax is added twice.. :S

[CC]

Quote

3. :?: Why you have bild the Adresstables one below the other ?
The release bevore they were side by side. That lokked better.

The last release only had 2 address sections for alteration.

This has one for seperate Invoicing Address, Delievery Address and Billing Address. You wont fit all 3 side by side.

Just alter it though if you need to.
Set the back alongside if thats how you prefer it.

[cgchris99]

Any chance you can add the ability to Create orders as well.

We need the ability to manually create orders for customers. When they call by phone and give us their credit card info and the items they want, I want to be able to enter that into my store.

Thanks for any info

[cgchris99]

Jonathan,

Any chance you can make a contribution for that screen shot of the Orders.php you created.

Some of that information could be very nice to see at a glance.

[GFW]

Quote

Any chance you can add the ability to Create orders as well.

We need the ability to manually create orders for customers. When they call by phone and give us their credit card info and the items they want, I want to be able to enter that into my store.

Thanks for any info

have you tried the manual order entry module contrib?

Hope there is a way for fixing the tax issues on your contrib so that all sums are displayed without tax and then all additional lines created are calculated with the tax

[cgchris99]

From what I read about Manual Order entry, the installation is a pain and it installs many things not just the Manual Order Entry. I keep hoping someone comes up with a good solution.

[End]

Still I can´t see my products under the "Choose a product" dropdown, the products displays as a blank field.