Search options (Page 11 of 12)

Yes I have seen that, but since each upgrade may (will likely?) require db changes it would be a good safeguard for cases where a company was overlooked.

$version says what version the code is and a db entry tells you what version the db has been updated to.

They could be the same value so that when $version != $row['version'] then we need to warn user that the db may need to be upgraded.

tom

Is there a field in the database that indicates the release version?

That will be helpful to add-on modules to see if they work or not...

tom

I see stock_matster and item_codes

Why do they both have category_id?

Since item_codes.id is the key what is the meaning of a specific stock_id appearing more than once? Will they have different category_id's?

Also there is a Quantity field, isn't the quantity of a given item determined by looking it up in Stock_Moves as menti0ned above?

I would like to update items_import, but will need to understand what needs to be done in very simple terms.

I may be able to take initial stock quantities at the same time, but I think that is a secondary step at th moment...

tom

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