osc_orders - which osCommerce?

@apmuthu:

I would be surprised if anyone was using FA 2.4.x osc_orders except me, but even then I use a customized version.   I still use osCommerce v2.2RC2a but will be discontinuing it in the near future.

The roll-your-own web store has been waning in popularity and I doubt that almost anyone would use osCommerce  for new installations.  Rather, webbuilders and canned web sites along with commercial integrated accounting seem to be the popular choice at the moment.

The db_prewrite/db_postwrite hooks in hooks.inc may be what you are looking for.

Note that the FA2.4 osc_orders now supports two methods of order processing.  The first is the method that you are using when you wrote the original module: import OSC sales orders and process them in FA.   The second is the method that I wrote that imports completed orders as paid direct invoices.   In this method, all handling of the customer (shipping/payment/customer email/etc) is done in OSC.    The first method is useful when FA is used to handle A/R, statements, aging, invoicing.   The second method is useful when the orders are prepaid, which is the usual mode of online stores.

Yes, unfortunately the db hooks for debtor_master transactions are missing.

FA doesn't support two customers with the same customer short name so it is unclear to me how you were able to handle duplicate OSC names unless you put some unique identifier in the customer short name.

The second method can work just like the first method in using the OSC name for the customer.    The separate feature of mapping all the OSC names into a single customer name is useful if one does not care about the names in FA.   Originally, because each customer could have a separate tax rate, customer branches had to be defined for each tax rate.  That scheme breaks down if there are a zillion different tax rates which is really a problem with FA.  Thus, in my FA core, I no longer use pre-assigned tax rates but instead grab them from an off-site provider, just like the way currency rates work.     I modified OSC for the same reason, and the tax algorithm and rates have to match in order for the order to successfully imported into FA.

Be prepared for change from the South Dakota v. Wayfair decision.  States want to collect sales tax from out-of-state retailers based on the tax jurisdiction of the customer, including municipal and overlay tax districts.   Because of South Dakota v. Wayfair, In-state retailers will be required to follow the same rules.   In Colorado we have 733 possible tax rate outcomes based on the customer address, and the city or zip code in the address is insufficient to make that determination.

It take a pretty large company to hit these targets:

Conducts 200 or more separate retail sales of tangible personal property or taxable services for delivery in Florida; or
Conducts any number of retail sales of tangible personal property or taxable services for delivery in Florida in an amount exceeding $100,000

200 sales in a specific state or $100k per year

All these sales tax reforms have exclusions for smaller businesses

Anyone bigger won't be using osCommerce for sure

tom

Yeah, ok.

COnsider these facts:

1 - It does not appear that very many people would are using the osc_orders addon
2 - osCommerce is pretty old, so anyone having $100k in sales would likely not be using it

A taco stand is not likely to use osC, osC is a web store, having 200 transactions within a 10 mile radius of a given *remote* location is a long shot

I pay all the sales tax I am bound to pay in Florida, as a PERSON I can not be required to follow all the tax laws of all 50 states, it is an unnecessary burden upon me.

There is a huge difference between me and Wayfair and most people using osCommerce (or any Free e-commerce solution) are likely not big enough to be included.

I wonder what they are smoking on Colorado to think they can enforce sales tax laws like that on individuals. (you said all Deliveries)

Tom

Isn't it time govts stopped interfering with businesses?
Americans should not vote for such reps who try to bully businesses.
Any place is just as rich as the number of goods and services available to it and such laws are not making it conducive for it either.
Why should brick-and-mortar shops complain - they too can go the internet way even if delivering to their neighborhood!

The following make for good reading:

https://www.cpapracticeadvisor.com/sales-tax-compliance/article/12402391/the-future-of-the-online-sales-tax-part-1
https://www.cpapracticeadvisor.com/sales-tax-compliance/article/12402389/the-future-of-the-online-sales-tax-part-2
https://www.avalara.com/taxrates/en/blog/2014/07/future-internet-sales-tax-internet-tax-freedom.html
https://www.brookings.edu/blog/up-front/2018/07/16/the-history-and-future-of-the-retail-sales-tax/
Sales Tax base has been shrinking and the ST Rate has been increasing!

If I have 22 tax rates in osc and FA and like I said above I update them every year as I get noticed from DOR, why would you think I am doing it wrong?

I collect and pay at the tax rate of the delivery location of each Florida order, I have done so for almost 20 years.

Tom

I think that the Sales Tax should be collected at the point of SALE (Not Delivery)

So if my state encourages business then IT should reap the benefits.

It also makes it much simpler for the businesses to collect and pay.

Ya know Florida expects it's citizens to report and pay sales tax on any untaxed mail orders.

Tom

from http://floridarevenue.com/taxes/taxesfees/Pages/sales_tax.aspx

There are 22 counties in Florida, so I only have 22 different sales tax zones that I need to worry about.

Sales tax is ONLY calculated on a COUNTY basis.

I think you like to make things overly complex.

Tom