Search options (Page 14 of 15)

Here is the osCommerce SQL to dump items.

I may not be able to use this directly, because I will need to figure out my units

I also have a number of sales kits I need to remove and add by hand

tom

I agree.

Thanks for helping me understand it better.

tom

Ok maybe I misspoke...

I just did some more testing and I see that if I change the address in the branch it does not effect the Sales Order.

So what effect will modifying the Branch have on any current or past sales orders (or invoices or...)?

I saw the "Retail Customers" in the demo an have considered putting all the web orders under a single FA customer and using the branches for each individual osC customer address.

And if the customer changed their address, I was going to update their FA Customer Branch accordingly.

I am just looking for any bad things that could happen by doing things this way...

If this will work, then I just need to have the osC 'order process' generate a sales order and then the normal FA interface can be used for the rest of the process.

I am very content to continue to use osC to interface with the customer because that works well. I need FA to track the *rest* of the business!

[edit]
Upon thinking about it more...

I can not think of a good reason to not create a FA user for each osC user
(except maybe lazyness LOL)

At that point I might as well create Branches on the fly as Ship To addresses
change... which it typically rare with my customer base

It then may make the most sense to do everything from the Order Process function in osCommerce.
That may keep things simpler in the long run...

tom
ps. let me know if there is a better place to discuss this kind of thing

Try SETUP->Display Setup
Prices/Amounts

tom

"scenario you describe is best"

I assume you mean a manufacturing process.

I still think I am missing something:

Selected Product: BLANK CD (Q=1)
Supplier Purchasing Data
Price: $24.00
Suppliers Unit of Measure: 24
Conversion Factor (to our UOM): ???
Supplier's Code or Description: CDRW-24

It just seems to me to be such a common activity that we should be able to do this purchasing directly:
If my supplier has a case of 24 "Supplier Code" CDRW24 at a Price of $24 (ie $1 each) and a supplier unit of measure 24
(not sure what to do with Conversion Factor)

When receiving this product the system could add 24 Blank CD's to inventory

Is a manufacturing process the only way?
(ie- is opening a box of 24 items and putting them on the shelf considered a manufacturing process?)

Tom

I think it would help some people (including ME ) if the demo data included purchasing in case quantities for maybe the CD ROM drive or something new.

There may be other features that could be better explained via the demo

I would be happy to work with someone to set up some examples I can understand (then *anyone* should be able to)

I too am interested in osCommerce interfacing.

I looked at the API document, I was hoping for APIs like add_customer and add_customer_branch, add_order etc

In osCommerce there is heavy use of Classes and the class functions are called from the web pages and the webpages only focused on display.

The class functions provided the API for any caller, making add-on modules
and the like much easier.

From the looks of the directory structure classes are not used here...

that mans when table changes are made each php file that uses that table needs to be updated... hopefully I am wrong...

tom

I have a similar problem.

I can buy an item in case quantities or as single units.

In my manufacturing process I cut them in 1/2 to make a finished product.

I also purchase bulk product (20kg or 44lbs and in some cases 50lbs)
and sell 1/4, 1/2, 1lb units

What is the best way to do these?

tom

t sounds like a retailer may have to pay some VAT on the goods they purchase for resale and then that need to be able to offset what they have already paid vs what they collect from the customer.

(Am I guessing correctly?)

Generally in the US we file as tax exempt and then pay the taxes on any goods we consume.

My wife (for example) pays sales tax of List price and then if she sells anything at a discount she needs to request a refund of the difference.

You are being very helpful

tom

So it seems I will have 6 Tax types
FL @ 6% and 5 for the various surcharges used within the state

and then 68 Tax Groups, one for each of the 67 counties
Pasco County (FL 6% + Surcharge 1%)
etc

and one for the rest of the world (Exempt)

And I see how I can link the Customer Branch to the proper Tax Group

ok and I see the Item Tax type can be used to tax different items at different rates (or exempt)

(I am enumerating al this in hopes of the example being useful to others)

Thanks
Tom

ps.

On
http://..../fa/index.php?application=system

I think 'Taxes' should be changed to 'Tax Yypes'