Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Recommended Posts

Beta 0.4

 

To do list:

  1. update qtprodoctor.php
    hardcoded stuff, superglobals
    language constants/definitions
  2. update stats_low_stock_attrib.php
    hardcoded stuff, superglobals
    language constants/definitions
  3. update stock.php
    hardcoded stuff, superglobals
    language constants/definitions
  4. replace mods in admin/boxes/tools.php by separate file
  5. replace mods in admin/boxes/reports.php by separate file
  6. avoid mods in admin/includes/functions/general.php => not possible
    load function file in modules=> not possible
    replace core function mods by own functions? => not possible
  7. modularize product info options
  8. modularize product info stock table
  9. versions for Modular Product Page by kymation
  10. alternative product listing module for modularized shopping cart
  11. order class extension to avoid mods in core order class
  12. replace all mods in checkout files by hooks?
  13. Integrate database changes in product info module
  14. Move stock checks in checkout_payment.php and checkout_confirmation.php to ht module
  15. Add spanish and german translations
  16. check compatibility with ajax attribute manager
  17. add support for attribute sort order
  18. update instructions

 

Beta 04 installation

Who has the old version already installed:

  • upload (and replace) all files in "New Files for 2.3.4 BS"

  • install the product info content modules and (IMPORTANT!) uncomment the complete options/attributes section in product_info.php

  • undo all modifications of the old version in:

    • admin/includes/language/all files
    • includes/language/all files
    • includes/classes/orders.php
    • includes/functions/general.php
    • checkout_payment.php
    • checkout_confirmation.php
    • checkout_process.php

    use the files included in: "Modified files for 2.3.4 BS" or compare and apply the changes. (hook registry and hook calls)

    • keep the modifications in admin/includes/functions/general.php
    • keep the modifications in includes/application_top.php
    • keep the modifications in shopping_cart.php or use the included content module "product listing qtpro" instead of "product listing" for the modularized shopping cart. If you do not have the latest EDGE version with hooks support: Use the included application_top.php and copy: legacy/includes/classes/hooks.php

    Install modules: admin -> modules -> header tags -> QT Pro Stock Check admin -> modules -> content -> QTPRO Options [product_info] admin -> modules -> content -> QTPRO Stock Table [product_info] admin -> modules -> content -> Product Listing QTPro shopping_cart

For new installations:

instructions are not updated yet

  • upload (and replace) all files in "New Files for 2.3.4 BS"
  • uncomment the complete options/attributes section in product_info.php instead to apply the mods
  • use the files included in: "Modified files for 2.3.4 BS" or compare and apply the changes.

    If you do not have the latest EDGE version with hooks support: Use the included application_top.php and copy: legacy/includes/classes/hooks.php

    • admin/categories.php
    • admin/products_attributes.php
    • admin/includes/functions/general.php
    • includes/application_top.php
    • checkout_process.php

    • shopping_cart.php if not modularized or use the included content module "product listing qtpro" instead of "product listing" for the modularized shopping cart.

 

 

 

Thanks

Link to comment
Share on other sites

@@raiwa

I am at beta 3 right now, so maybe beta 4 will fix things.

 

But I am getting mixed results on the product info page when I select different options in the QTPro options module.

Depending on the display I choose I am sometimes seeing different results

EX when Show Out of Stock Attributes is negative

 

With Product Info Attribute Display Plugin set to single_dropdown and single_radioset

I see the 8 mb memory although the value is zero

 

With multiple_dropdowns it's hidden

 

Anyway, I'll get to beta 4 and see what that does.

 

It's nice to see the affected core files reducing with each release.

I am not a professional webmaster or PHP coder by background or training but I will try to help as best I can.

I remember what it was like when I first started with osC. It can be overwhelming.

However, I strongly recommend considering hiring a professional for extensive site modifications, site cleaning, etc.

There are several good pros here on osCommerce. Look around, you'll figure out who they are.

Link to comment
Share on other sites

Hello Steve @@altoid,
 

With Product Info Attribute Display Plugin set to single_dropdown and single_radioset
I see the 8 mb memory although the value is zero
 
With multiple_dropdowns it's hidden

 
I just checked and it seems for me it works correct:
Example product: Matrox G200 MMS
Stock quantities:
Premium 4 mb 10
Value   4 mb 1
Premium 8 mb 0
Value 8 mb 0
 
Displayed options (single_radioset):
4 mb, Value $279.99
4 mb, Premium $379.99
8 mb, Value $349.99

Same for single_dropdown

Can you please post your exact sample data.
 
Small To Do List update:

15. Add spanish and german translations thanks to @@Lioelx
16. Add installation checks to all modules
17. Merge standard and modular product info product listing module by kymation into one universal module
18. check compatibility with ajax attribute manager
19. add support for attribute sort order
20. update instructions

 

 

Thank you

Link to comment
Share on other sites

@@raiwa couple issues with adding attributes

 

1) looks like you may have a mix if old products_attribute.php with .gif buttons....

 

2) when adding a new product attribute getting this

 

1136 - Column count doesn't match value count at row 1

insert into products_attributes values (null, '6442', '18', '119', '2.6', '+')

[TEP STOP]

Adding option name and value was fine.... just when attaching the product....

Link to comment
Share on other sites

@@greasemonkey
 

1) looks like you may have a mix if old products_attribute.php with .gif buttons....

Thank you, fixed in Beta 05

 

2) when adding a new product attribute getting this

Adding option name and value was fine.... just when attaching the product....

Checked this and it works for me. Can you check if you are using the included admin/product_attributes.php file or did you apply the changes by instructions?

 

rgds

Rainer

Link to comment
Share on other sites

ut I am getting mixed results on the product info page when I select different options in the QTPro options module.

Depending on the display I choose I am sometimes seeing different results

EX when Show Out of Stock Attributes is negative

 

With Product Info Attribute Display Plugin set to single_dropdown and single_radioset

I see the 8 mb memory although the value is zero

 

With multiple_dropdowns it's hidden

 

Anyway, I'll get to beta 4 and see what that does.

 

It's nice to see the affected core files reducing with each release.

Can you please check with Beta 05

Link to comment
Share on other sites

Beta 05

changes:

  • all language definitions revised and added to product info module the definitions for modified core files (admin/categories, admin/product_attributes)
  • fixed bug for duplicate listing in admin/stock.php under PHP7
  • merged support for modular product info by kymation into base module
  • fix class constructor name in header tag and pad base
  • moved stock check functions to pad base (no need to modify in /functions/general.php any more)

Please replace all files, see git hub for details

 

QTpro BS 5.0 beta_05.zip

 

Updated to do list:

  1. Add spanish and german translations
  2. Add installation checks to all modules
  3. Merge standard and modular product info product listing module by kymation into one universal module
  4. check compatibility with ajax attribute manager
  5. add support for attribute sort order
  6. update instructions
Edited by raiwa
Link to comment
Share on other sites

Can you please check with Beta 05

Will work on this in the next day or so.

I am not a professional webmaster or PHP coder by background or training but I will try to help as best I can.

I remember what it was like when I first started with osC. It can be overwhelming.

However, I strongly recommend considering hiring a professional for extensive site modifications, site cleaning, etc.

There are several good pros here on osCommerce. Look around, you'll figure out who they are.

Link to comment
Share on other sites

update to beta 5

With these settings, 

Show Out of Stock Attributes
True

Mark Out of Stock Attributes
Right

Display Out of Stock Message Line
True

Prevent Adding Out of Stock to Cart
True

Use Actual Price Pull Downs
False

 

Here's what I see for the various displays for Product Info Attribute Display Plugin with memory of 8 mb out of stock for both models:

 

Base:

8 mb shows, no out of stock message and I am able to add to cart

 

multiple_dropdowns

8 mb shows, with out of stock message. When trying to add to cart this popup shows:

The combination of options you have selected is currently out of stock.  Please select another combination.

 

sequenced_dropdowns

8 mb does not show

 

single_dropdown

8 mb shows with out of stock message. Trying to add that to cart gives pop up notices.

 

single_radioset

8 mb shows with out of stock message. Trying to add that to cart gives pop up notices.

 

In the edit mode for qt pro options..looks like a language mix up:

Admin Stock Warnning ENGLISH
Definición de idioma usado en admin QT Pro Stock

 

Out of the edit mode I see:

Admin Stock Warnning ENGLISH
Warning: There are %s sick products in the database. Please visit the QTPro doctor

 

Clicking that link, I get a page with this error on it:

Bad Request

Your browser sent a request that this server could not understand.

 

That's it for now

 

I am not a professional webmaster or PHP coder by background or training but I will try to help as best I can.

I remember what it was like when I first started with osC. It can be overwhelming.

However, I strongly recommend considering hiring a professional for extensive site modifications, site cleaning, etc.

There are several good pros here on osCommerce. Look around, you'll figure out who they are.

Link to comment
Share on other sites

@@raiwa

 

Checked this and it works for me. Can you check if you are using the included admin/product_attributes.php file or did you apply the changes by instructions?

Stay tuned... I was using the included file but have SPPC installed (SPPC adds a column to the products_attributes table).

 

I need to modify my file.

Link to comment
Share on other sites

Hello Steve @@altoid,
 
Thanks for testing.
 

Base:
8 mb shows, no out of stock message and I am able to add to cart

The old "display plug info" file says:
"This base class, although functional, is not intended to be installed and used directly"
so I think it's better not to offer it to avoid confusion. All the additional options do not work with it.
I removed that option.
 

multiple_dropdowns
8 mb shows, with out of stock message. When trying to add to cart this popup shows:
The combination of options you have selected is currently out of stock.  Please select another combination.

Correct and the same like the old one works
 

sequenced_dropdowns
8 mb does not show

Correct and the same like the old one works.
The old "display plug info" file says:
"Display stocked product attributes..."
I added a note to the "Show Out of Stock Attributes" option.

 

single_dropdown
8 mb shows with out of stock message. Trying to add that to cart gives pop up notices.

Correct and the same like the old one works.
I added a note to the "Display Out of Stock Message Line" option.
 

single_radioset
8 mb shows with out of stock message. Trying to add that to cart gives pop up notices.

Correct and the same like the old one works.
I added a note to the "Display Out of Stock Message Line" option.
 

In the edit mode for qt pro options..looks like a language mix up:
Admin Stock Warnning ENGLISH
Definición de idioma usado en admin QT Pro Stock

Seems you didn't use the latest version included in Beta 05, it is fixed there.
 

Out of the edit mode I see:
Admin Stock Warnning ENGLISH
Warning: There are %s sick products in the database. Please visit the QTPro doctor
Clicking that link, I get a page with this error on it:
Bad Request
Your browser sent a request that this server could not understand.

I truncated the text display now, the link is not shown any more. It is not intended to be used there, it is the text used in the header message if sick products exist. There the link works correct.

 

Thanks again. I'll go ahead with the last "To Do" points.

 

rgds

Rainer

Edited by raiwa
Link to comment
Share on other sites

Small To Do List update:

 

  1. Add spanish and german translations
  2. Add installation checks to all modules (in GitHub only for now)
  3. Merge standard and modular product info product listing module by kymation into one universal module
  4. check compatibility with ajax attribute manager
  5. add support for attribute sort order
  6. add support for paypal standard
  7. update instructions
Link to comment
Share on other sites

@@raiwa

That languages issue was because I didn't uninstall that module before I updated the module file. An uninstall and reinstall fixed that.

 

Testing adding product with options for

Model Memory Price Qty. Value 4 mb $299.99 1

 

mg200mms.gif Matrox G200 MMS
- Memory 4 mb
- Model Value
 

 

In shopping cart, when I change the number order to 4 and refresh..

 

I do not get a notice of ordering more than is in stock.  I am able to click Checkout.

 

Ran a test checkout, completed successfully with

 

4 x  Matrox G200 MMS
  - Memory: 4 mb
  - Model: Value

 

In admin stock shows -3

Edited by altoid

I am not a professional webmaster or PHP coder by background or training but I will try to help as best I can.

I remember what it was like when I first started with osC. It can be overwhelming.

However, I strongly recommend considering hiring a professional for extensive site modifications, site cleaning, etc.

There are several good pros here on osCommerce. Look around, you'll figure out who they are.

Link to comment
Share on other sites

Hello Steve @@altoid,

 

Thank you. Yes, I forgot to apply an update for the unmodularized shopping cart you are using. I made all my tests with the shopping cart module.

 

@@raiwa

In shopping cart, when I change the number order to 4 and refresh..

 

I do not get a notice of ordering more than is in stock.  I am able to click Checkout.

Please:

- update the header tag module

- apply the changes like in the new added shopping_cart.php or use that one (first instance of "tep_check_stock" changed to "check_stock_qtpro")

Ran a test checkout, completed successfully with

 

4 x  Matrox G200 MMS

  - Memory: 4 mb

  - Model: Value

 

In admin stock shows -3

This may have happened if you did not have the header tag module installed or updated.

- The shopping cart allows checkout and forward until checkout_payment.php. It only should show the out of stock message

- in checkout payment.php and checkout_confirmation.php a stock check is performed via header tag and should redirect to shopping cart if no stock

- another stock check is performed in checkout process via hook. This should have worked. Can you please check the hook and checkout process files for newest versions

 

 

 

Please update all qtpro modules and the 3 new qtpro files in admin, also update all language files. Installation checks are now included.

Always uninstall and reinstall all modules when updated.

 

rgds

Rainer

Edited by raiwa
Link to comment
Share on other sites

@@raiwa

Are the most up to date files on the github repo?

I am not a professional webmaster or PHP coder by background or training but I will try to help as best I can.

I remember what it was like when I first started with osC. It can be overwhelming.

However, I strongly recommend considering hiring a professional for extensive site modifications, site cleaning, etc.

There are several good pros here on osCommerce. Look around, you'll figure out who they are.

Link to comment
Share on other sites

@@raiwa

Using the files from the github, I completely wrote over existing files from new and modified files in qtpro-5.0-BS-master

and then reinstalling,  I see this happed during a trial purchase:

 

Adding a Value Model with 8 mb to the cart

 

Model Memory Price Qty. Value 4 mb $299.99 1 Value 8 mb $349.99

1

 

Noting there's just one of those in stock.  On the shopping cart page when I update the quantity to 2 and refresh this message appears.

 

Matrox G200 MMS***
- Memory 8 mb
- Model Value

Products marked with *** dont exist in desired quantity in our stock.

You can buy them anyway and check the quantity we have in stock for immediate deliver in the checkout process.

 

Continuing through the checkout process...

 

checkout_shipping > checkout_payment > checkout_confirmation

 

Showing:

 

2 x 

Matrox G200 MMS
  - Memory: 8 mb
  - Model: Value

 

I get to checkout_success and done.

 

In admin I see this message:

 

Warning: There are 1 sick products in the database. Please visit the QTPro doctor.

 

QT Pro Doctor says:

 

You currently have 28 products in your store.
3 of them have options with tracked stock.
In the database we currently have 0 trash rows.
1 of the producks with tracked stock is sick.

Sick products in the database:

Product with ID 1: The summary stock calculation is wrong. Please take a look at this products stock.

 

Clicking products stock I see duplicate warnings at the top:

 

error.gif Warning: There are 1 sick products in the database. Please visit the QTPro doctor

Warning: There are 1 sick products in the database. Please visit the QTPro doctor.

 

Noting stock for that Value 8 MB

 Value    8 mb     -1

 

Below  I click on:

Automatic Solutions Avaliable:

Set the summary stock to: 14

 

QT Pro Dr is happy now but in stock for that item stock shows:

 

 

 Model   Memory Quantity      Value    16 mb     5      Premium    16 mb     6      Value    4 mb     1      Premium    4 mb     2      Value    8 mb     -1  

 

That's it for now

Edited by altoid

I am not a professional webmaster or PHP coder by background or training but I will try to help as best I can.

I remember what it was like when I first started with osC. It can be overwhelming.

However, I strongly recommend considering hiring a professional for extensive site modifications, site cleaning, etc.

There are several good pros here on osCommerce. Look around, you'll figure out who they are.

Link to comment
Share on other sites

Hello Steve @@altoid,

 

I fixed the stock error message in the sense that now qtpro doctor doesn't count negative stock neither for attribute stock nor for total product quantity when comparing.

This produced before the error.

Negative stock is allowed and correct if allow checkout is set to true. In an unmodified store stock result is also -1 if doing your example.

 

Please update with the actual GitHub files and check again:

- admin/includes/functions/qtpro_functions.php

- admin/includes/languages/english/stock.php

 

For the duplicated message, I couldn't recreate, is it possible that you have still the qtpro stock message modification in your admin/includes/template_top.php?

I also saw that in your GitHub repositorie's shopping_cart.php the change of Beta 5 isn't done:

      if (STOCK_CHECK == 'true') {
//++++ QT Pro: Begin Changed code
        if (isset($products[$i]['attributes']) && is_array($products[$i]['attributes'])) {
          $stock_check = check_stock_qtpro($products[$i]['id'], $products[$i]['quantity'], $products[$i]['attributes']); 
        } else {
          $stock_check = tep_check_stock($products[$i]['id'], $products[$i]['quantity']);
        }
//++++ QT Pro: End Changed Code

in line 90 it must say: "check_stock_qtpro" not "tep_check_stock".

 

Make also sure to do all checkouts with cod or similar, not with paypal_standard. I'm still working on that support.

 

Thanks

Rainer

Link to comment
Share on other sites

@@raiwa

I'll update with what you advised and check things out on the test shop.

 

Regarding my repo, I apologize, I got backed up and haven't kept that up to date. I'll do that with files from your repo which should get it up where it needs to be.

 

Thanks for working on the QT Pro modification > BS.  It'll surely help folks out.

I am not a professional webmaster or PHP coder by background or training but I will try to help as best I can.

I remember what it was like when I first started with osC. It can be overwhelming.

However, I strongly recommend considering hiring a professional for extensive site modifications, site cleaning, etc.

There are several good pros here on osCommerce. Look around, you'll figure out who they are.

Link to comment
Share on other sites

@altoid

I am updated from Github. 

Regarding that duplicate message, I don't see anything in admin/includes/template_top.php

 

Going through that again..when ordering a Value 8 MB card, where there is only one in inventory when completed over on the admin side when on the index.php page, I see just one notice:

 

Warning: There are 1 sick products in the database. Please visit the QTPro doctor.

 

It appears only with the catagories.php page, I see two notices now:

 

error.gif Warning: There are 1 sick products in the database. Please visit the QTPro doctor

Warning: There are 1 sick products in the database. Please visit the QTPro doctor.

 

Seems something specific to categories.php?

I am not a professional webmaster or PHP coder by background or training but I will try to help as best I can.

I remember what it was like when I first started with osC. It can be overwhelming.

However, I strongly recommend considering hiring a professional for extensive site modifications, site cleaning, etc.

There are several good pros here on osCommerce. Look around, you'll figure out who they are.

Link to comment
Share on other sites

Hello Steve @@altoid,

 

I just checked again:

- if you get the error message in admin/index.php, there must be the old code still in admin/template_top.php:

<?php //++++ QT Pro: Begin added code

$qtpro_sick_count = qtpro_sick_product_count();
if($qtpro_sick_count != 0){
?>
<table border="0" width="100%" cellspacing="0" cellpadding="0"><tr><td class="messageStackWarning"><?php echo 'Warning: There are '. $qtpro_sick_count . ' sick products in the database. Please visit <a href="' . tep_href_link(FILENAME_QTPRODOCTOR) . '" class="headerLink">the QTPro doctor</a>.'; ?></td></tr></table>
<?php
}
//++++ QT Pro: End added code ?>

In the new version it should only be added to these files:

- admin/categories.php

- admin/products_attributes.php

- admin/stats_low_stock_attrib.php

between:

  require('includes/application_top.php');

and:

  require('includes/template_top.php');

In beta 05 it was also in admin/stock.php, but I removed it now, doesn't make sense there.

 

 

I did again a checkout with value 8MB stock set to 1 and purchasing 1 or 2 and I do not get an error message any more on my installation.

Stock result should be now 0 or -1, but no error message given.

Can you please double check.

 

thanks and rgds

Rainer

Link to comment
Share on other sites

Steve, @@altoid,

 

If you still get these errors, can you please make sure that your Git Hub repository is up to date with your test installation.

I'll then download tomorrow your complete files and try to reproduce on a local test inslallation with your files.

 

Thanks

Rainer

Link to comment
Share on other sites

@@raiwa

 

Found it

 

admin/includes/header.php

 

Got there from the original instructions it looks like.

I am not a professional webmaster or PHP coder by background or training but I will try to help as best I can.

I remember what it was like when I first started with osC. It can be overwhelming.

However, I strongly recommend considering hiring a professional for extensive site modifications, site cleaning, etc.

There are several good pros here on osCommerce. Look around, you'll figure out who they are.

Link to comment
Share on other sites

Hello Steve @@altoid, Scott @@greasemonkey, Lionel @@Lioelx, Joe @@joe122joe and others,

 

Thanks for all your help. The Beta 06 final pre release is finished.

If you would like to give it a try.

QTpro BS 5.0 beta_06.zip

 

Installation and Update instructions for 4.6.1 included.

 

rgds

Rainer

Link to comment
Share on other sites

Final release uploaded:

http://addons.oscommerce.com/category

 

Changes versus Beta 06:

- added auto remove old configuration entries to product info options module when installed

- small fix in installation and update instructions for admin/products_attributes.php step 2.3.b

- spanish translations updated

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...