Jump to content


  • Content count

  • Joined

  • Last visited

Posts posted by Zappo

  1. Please let me know if I DON'T GET IT, as I really need to understand how OS Commerce is put together.

    Ah, I'm sorry. Indeed you DO seem to get it.


    However the x-sell module has nothing to do with the Linked Products contribution...

    I am planning to add such functionality in the future...

  2. When I said "Linked Products" Earlier I didn't realise there was a number of different modules you could use.


    I have the default x-sell module installed.


    To use the easypopulate madule, it can only update the products and products_description tables. Does anyone know where the x-sell puts the linked product items to? Is it in a field in either of these tables ??

    I think you don't get it...

    No contribution just automatically works like that.

    You'll have to write your own code to get something to work with another contribution.


    If you DO get it: Yes, Linked Products uses 2 dB fields in the TABLE_PRODUCTS (type_id and linked_products)

  3. Sage Line 50 is our stock control system so I get it to automatically pull our orders across. With the Master Products contribution this is no good as it will pull the Master Product code (model) across. I need it to pull across the codes (or model) for each of the items that make up the Master Product.

    I still don't entirely understand what you want to be able to pull for every (Linked) Product and how you want to process that data, but Linked Products is far less "Rigid" than Master Products, and it should be possible to have it do exactly what you want.

    In the current release of Linked Products, the "Linked Products" are put in the cart as separate products, with or without the "Main (Master) Product".

    Currently, there is no way of tracking from what "Main Product" the "Linked Product" was bought.


    Is that what you are looking for (a field that shows what the "Main Product" is/was?)

  4. Certainly sounds like it will do what I need as the Master Products contribution doesn't quite do what I need. I need to be able to show a bathroom suite for sale that is made up of X items and I need each of the X items to be passed through as the items on the order rather than the single master item. These can then be passed automatically to the Sales Orders in Sage Line 50. Would it be possible for your contribution to pass each sub-item for the order as opposed to the master item?

    Hello Mark,


    I think everything should work for you.

    The Products can be passed as if they where bought separately (each product get's put in the cart as 'normal' product)

    However, I don't know what you mean with "the Sales Orders in Sage Line 50"?

  5. I am looking to implement a 'B' grade product system whereby I want to link say a "damaged" product ( with new productID ) to the "undamaged" one.

    Could I use the liked products to link them so the customer would see the full value item, and then the reduced rate item as a linked product ? This may intice the customer to take the damaged product?


    Also, I upload my products as a CSV using th easypopulate method. Would it be possible to add the linked here to save time?

    Yes, I think Linked Products would do that job just fine!

    You could show the "damaged" product (with pricing) as linked product of the undamaged one, so the customer can choose between the two.


    I never used easy populate, so I have no idea about it's workings...

    I'd imagine this should be possible... (only two columns to add to TABLE PRODUCTS: type_id and linked_products)

  6. Do you have any place to see it working?

    Hello Cesar,


    No, I don't have an example store setup.

    However, there are Screenshots available in the package....


    I now see, the package I was talking about is not available yet.

    It was quite a big upload, and probably has to go through manual checking...

  7. After using the contribution "Master Products" for quite a while, I found "Master Products" to be overly complicated and very difficult to use or merge alongside other contributions.

    I wrote this new contribution: "Linked Products", (in combination with an other contribution: "Product Types")

    you'll get a lot of the same functionality as the "Master Products" contribution.

    Maybe worth a look?


    The Linked Products Contribution page can be found here: http://addons.oscommerce.com/info/6842

    The support Thread can be found here: http://forums.oscommerce.com/index.php?showtopic=339538

  8. This contribution is built on top of osCommerce 2.2rc2a.

    It adds a "Type" to Products and Categories

    This allows us to group products (and categories) together, and use these groups in various ways:

    Basically, with this Contribution you can make "Presets" for products and categories.

    You can add functionality to these "preset" Product Types through the Admin area.


    This is also the Support Thread for the "Replace Buttons" Add-On.


    Please Note, adding such functionality gets EASIER, NOT AUTOMATED! Some programming will (almost) always be needed, except for available Options and Contributions


    The Contribution can be found here: http://addons.oscommerce.com/info/6839

  9. I currently have the older "Product Attributes - Option Type Feature" installed and working on my site but I really need to get passed the 32 max char limit for textboxes. How do you recommend I go about incorporating this contribution when I already have the other one installed?

    I recommend uninstalling the "Old" Option Type Feature, and installing Option Types v2... :lol:

    Simply "Merging" the two is impossible. There are too many differences...


    However, I have used the "Old" Option Type Feature a long time ago, and if it's just the Character limit, I believe that option is available via Admin, in "product_attributes" (Option Value Length)

    It SHOULD work as it does in Option Types v2....


    Ill give an example:


    Is this the first way or second way you mentioned

    In that case, at least the standard osCommerce behavior is kept.

    You'll be able to count the attributes already connected to a product...

    BUT, as I stated in an earlier post, this is not going to be a simple change!! You'll need at least SOME php skills...

  10. I mean that if you by 25 of an item, there will be for example a "one-time fee" of $.75 per attribute, and a $.25 fee per attribute that gets multiplied by 25.

    Ok, I get that, but with "an item" do you mean 25x the same product, OR 10x 'Product A', 10x 'Product B' and 5x 'Product C'?!?

    That makes a big difference, as attributes are (separately) linked to products.

    To osCommerce, 'Product A' with attribute 'Green' is not the same as 'Product A' with attribute 'Red'.... (which makes counting the number of added attributes somewhat difficult)

  11. Is it possible to have a "one-time" fee per attribute no matter the quantity, and a second recurring fee, that gets multiplied based on the quantity?

    That Should be possible, however you'll have to be willing to do some programming of your own...

    As I'm thinking of how to do this, I realize this isn't a very easy task...

    It would involve having a second price field for attributes, and different attribute handling (in application_top) when adding products.

    I'm not sure what you meant by quantity, but if you want the second fee to be used independent on the products selected, that would make things even harder...

  12. Have you thought about linking your attributes to stock, or stock via QTPro?

    Or in essence just giving your created attributes 'stock' so they get deducted as per sale?

    Actually, Yes, I have.


    However, I use accounting software that's linked to osCommerce. (osFinancials)

    Because of this, I have no use for QTPro. (I need to track real products for stock updating)

    I'll actually be creating an entirely new contrib: Products as Options.

    With that contrib, you'll be able to "group" products together as another product's Options:

    For example: Main product = Shirt, Option products = Red Shirt, Blue Shirt, Green Shirt

    When adding the product to the cart, it will use the selected Option Product as Main product...


    The big difference: products attributes are no "real products", and have no stock-tracking (inside my accounting software)

    Adding the Options as real products solves this problem...

  13. When i go in Admin and open Option Types ther is nothing there to be set. Title, Value, Action. Everything is emty.

    Whot i did wrong ??? Help ""


    I have no idea what went wrong, but I'm guessing the SQL file wasn't (properly) executed...

    Go into your phpMyAdmin, and check the table "configuration_group" for the Option Types entry, and note the "configuration_group_id" number.

    Then check the table "configuration", and find the Option Type values (use progress bars?, Upload File Prefix, Delete Uploads older than, upload directory and temporary directory)

    These probably don't have the correct configuration_group_id... Set it to the value found in configuration_group


    Lat me know if it works out.

    We'll try another fix if it doesn't.

  14. Each time i reloaded the page there was an empty field added to the attributes.


    So in line products_attributes.php comment out line 31.


    That should not happen...

    I am also unable to reproduce that behavior...


    You say an empty field is added to the attributes.

    What do you mean? Product Attributes, Option Values or Options?

    Since the particular code involves only Option Values, and should only trigger when Option Value Text is not (yet) correctly set, I don't understand what's going wrong here...

    BUT, since the code is only a "safety measure", everything should work normally.

    If you ARE going to comment out that line, you can comment out the lines 25 - 34. (- Zappo - Option Types v2 - Check if the option_value TEXT_UPLOAD_NAME is in place, and insert if not found)

    These are unnecessary when line 31 is commented out...


    Is anyone else able to reproduce this behavior?

  15. This contribution is built on top of osCommerce 2.2rc2a.
    It is an update/upgrade/revision/compilation of the following contributions:
    * Option Type Feature v3 (Originally by Chandra Roukema)
    * Option Type File Feature v.8 (Originally by Matt Fletcher)
    * AJAX Attribute Manager v2.8.6 ((Almost unchanged) Originally by Sam West)
    * Improvements by me (AvanOsch aKa Zappo the Wizard of Osch) 

    Please post questions, comments, request, etc. right here!

    The Contribution Page can be found here: http://www.oscommerce.com/community/contributions,xxxx

  16. From the path to the configure.php I would guess you are on a Windows server so settings like 644 don't make sense in a Windows environment. Don't know the equivalent Windows wording of that (read only?).


    I'm running wamp (Windows - Apache PHP MySQL) which is an offline (localhost) server for testing and building applications), and setting the file to 'read only' is actually the way to go for wamp...

    Online I'm on Linux, so don't know about that...

  17. It took me a lot of time to write this so a bit more time to make sure the install is correct and the only bugs left the one I overlooked is in order IMHO.


    But if you want to help in that process than I can email you what is ready.. tomorrow or so.


    Yeah sure, no problem, Please do.

    I have a totally clean installation setup and running (2.2rc2a) so that 'll make for good testing...


    Just send me whatever you have, and I'll comment on or add to that.

  18. These tables (as is mentioned in the install file I think) are only used when there a sorting/selection is needed on price in index.php or advanced_search_result.php. This could be done in heap files but not all MySQL installations provided that (need to be specially allowed by the hoster) so instead I chose to use these temporary tables. They don't hold any data you should be concerned about updating. It derives it data from products_groups and specials.


    Nowadays it probably could be done using subselects but then you need a minimum version of MySQL 4.1. At the time this was written this version was either brand new or not there yet.


    Thanx Jan!

    That clears up everything.

    I think I'll be removing the tables, and change everything to use the products_groups and specials tables...

    I'll have to see if I have time to make those changes into an update (As I haven't seen a server with a MySQL version < 4 in quite some time...)

    Maybe (If I'm pleased with my results, if Jan doesn't beat me to it, and again if time permits it) I'll even make an update to QPBPP for SPPC. (How's that coming, Jan?)



    Geez... You DID mention this in the install file... My bad...

  19. Forgot to mention, both those tables seem to only be used/accessed from index.php and advanced_search_result.php

    Seems to me, there should be no reason all data can't be stored in products_groups and specials tables:

    Why add a "products_group_" table for every group, when all that data can be stored in "products_groups"

    Why add a "specials_retail_prices" table, when "specials" contains all columns needed to store the data?


    I'm planning to add QPBPP (just like I had with my previous osC installation), but I really want to use both contribution's latest versions.

    Simplifying the tables of SPPC should make these a lot easier to merge...


    Thanks for any comments!