Product Display (main store page)

Every time we come across an issue, and it gets resolved, almost without fail another comes up within 24 hours?!? Just wondering, has this plugin ever been able to do what it's supposed to without issue, or is it that we're doing something wrong every step of the way? Really can't see that it's us, to be honest, and I'm pretty good at following instructions and generally catch on to things pretty quickly!

After getting a DB issue resolved, our store page will only show a maximum of 21 items no matter what we set the global short code at when inserting it (right now there are almost 40 products available that should be showing up on that page? What would you need now to view this, pretty sure access is still available under Network Admin for a super suer to view the primary site (www.frommy******yours.com/store). Please advise when you have a moment...

  • John
    • Site Builder, Child of Zeus

    So, we happened to find a short code online that someone posted and it actually paginates as it's supposed too, but it shows the same items on both pages instead of the remainder of items that aren't shown on the first page of 20 items (there are 37 items so far, and our INDEXED ITEMS count is 60 on the . Is this normal behavior?

    Additionally, it would appear that the "Add E-Commerce Short Code" function doesn't seem to work as it should, at least for our site, since I can't get it do what the code found in a random post online was able to do for us...

  • Tyler Postle
    • CGO

    Hey John,

    Sorry about the issues you've been facing.

    So, we happened to find a short code online that someone posted and it actually paginates as it's supposed too, but it shows the same items on both pages instead of the remainder of items that aren't shown on the first page of 20 items (there are 37 items so far, and our INDEXED ITEMS count is 60 on the . Is this normal behavior?

    The issue is that it hasn't actually indexed all your products - that 60 products indexed isn't correct. I'm thinking this might be related to the fix Jude provided for your last issue, I see he was doing some work in the DB. I'm messaging him about this so we can get to the bottom of it :slight_smile:

    Additionally, it would appear that the "Add E-Commerce Short Code" function doesn't seem to work as it should, at least for our site, since I can't get it do what the code found in a random post online was able to do for us...

    Are you using it on pages with the Visual Composer? It appears there is a conflict there since both come up in popups, our shortcode builder is behind the Visual Builder form. I'll report that as well and see if we can add some compatibility to make it play nicer with Visual Composer.

    In the meantime, the easiest way to use the shortcode builder would be to edit a page in the "classic" WP editor view and then once you've customized and inserted the shortcode you can copy it anywhere you like.

    Either myself or Jude will reply back once we have a more info/solution on your indexing issue.

    Talk to you soon!

    Cheers,
    Tyler

  • Jude
    • DEV MAN

    Hey John

    Took a look closely at your DB again, everything seems fine. Looks like the newly added products while they show up are not being pulled in the index because of this line of code in the hotfix

    $where = " WHERE post_status = 'publish' AND blog_public = 1";

    Can you confirm if you have installed the hotfix please ? I am not able to check this as I have only phpmyadmin and wp access at the moment.

    Cheers
    Jude

  • John
    • Site Builder, Child of Zeus

    The hotfix was uploaded to the child theme folder only (as were the corrected corresponding files previously used for customizing the product pages); would the hotfix need to be uploaded to the Marketpress plugin folder as well, and this line of code removed for it to be able to index correctly, or should we update that line of code to something else? Thanks...

  • John
    • Site Builder, Child of Zeus

    Ok, I'll add the hotfix to the plugin folder and re-index via the store network page. Am I supposed to be removing that line of code you referenced, Jude, or replacing it (sounds like that's WHY it's not indexing properly, if I read your response correctly). Thanks...

  • John
    • Site Builder, Child of Zeus

    Jude / Tyler / Luis,
    Here's what we're getting when the template-functions.php file class-mp-admin-multisite.php files were uploaded to marketpress/multisite. Doesn't seem to be working, still only getting 3 pages of items on the store page (www.frommy*******yours.com/store) and the index shows 112 / 82. Please advise...

    John

  • Panos
    • SLS

    Hey John ,

    Thanks for your feedback!

    After getting a DB issue resolved, our store page will only show a maximum of 21 items no matter what we set the global short code

    Could you please confirm if this has been resolved by changing the shortcode as mentioned in your other thread ?

    Regarding the indexer not sure why it's displaying the wrong number. The fix provided should be fixing the products on your global store pages, though it will be fixing this only for products added to subsites after fix is applied. It doesn't remove products of subsites that have been deleted prior the fix was applied. These need to be removed manually from the database so please let us know if we can remove them for you.

    I have attached the /wp-content/plugins/marketpress/includes/multisite folder which contains an additional fix regarding global categories which similar were visible when sub-site was deleted. I would suggest to download your previous multisite folder (to keep it as a backup) and then replace it with the one attached here.

    Please let us know how this works for you :slight_smile:

    NOTE: With the fix you should not need to re-index each time you activate/deactivate/delete etc a sub-site.

    Kind regards,
    Panos

  • John
    • Site Builder, Child of Zeus

    Panos,
    From what I understood the DB was already cleaned up by Jude per one of his previous replies, the items being added are still not showing and we're still not able to determine why though he stated something about that line of code ($where = " WHERE post_status = 'publish' AND blog_public = 1"; ) being the issue - not sure which of the two files to locate that in but didn't want to delete it until hearing back from someone.

    Once I'm off work, I'll download the existing file and upload the fix you've provided to see if that works - will we need to do anything further, or will this correct even with all the stores/products that have been established to this point (I'm going to pray that your response is NOT to delete and start all over again)? Thanks...

  • John
    • Site Builder, Child of Zeus

    The hotfix was applied, and the results are in the screenshots which show the same items on both pages 1 and 4 (and all 4 pages show the EXACT same 20 items).

    And I'm a bit confused: how was this never noticed before now? The plugin is several years old, has no one ever experienced this issue previously?

    Please advise, we're still not live and continuing to get further behind. Thanks...

  • John
    • Site Builder, Child of Zeus

    And here's the indexed info - I know you said we shouldn't have to manually index, but when we do it clearly shows a discrepancy, and I'm not even sure what that is indicating (shop page indicates 4 pages that have 20 items on each, albeit the same items on each page) and the Network Store Settings page shows 128 products indexed in whole network and 95 products "get" indexed...

    P.S. - when we don't use paginate, it shows 17 rows of 4 plus 1 single item at the end for a total of 69 items - that # is nowhere to be found in the item counts above, makes no sense at all. WTH is that all about?!? lol

  • John
    • Site Builder, Child of Zeus

    Ok, with the pagination issue resolved in the other support thread right now we're left with the issues of all products not showing up still while some are continuing to show as duplicates in the store page, on different pages (think we may have figured this out, see below).

    1) The sum of items on all 3 sites in the network show 96 products published (total products = 98) but only 70 seem to show in the four (4) pages on the shop page (www.frommy*******yours.com/store) no matter the setting. When we go to STORE NETWORK settings, it shows 137 products having been indexed, and when manually indexing it returns the correct# of 96 products, while our store page still only shows 70??

    2) The duplicates can be seen in the 1st set of screen shots taken this morning, after all corrections were made (i.e. hotfix was applied, shortcode was updated per Panos, etc.). However, after changing the shortcode itself seems the duplicates may no longer be an issue:
    * DUPLICATES SHOW - [mp_list_global_products paginate="1" per_page="20" list_view="0"]
    * NO DUPLICATES - [mp_list_global_products paginate="true" per_page="20" order_by="date" order="ASC" list_view="0"]

    Please advise at your earliest convenience. Thanks...

  • Panos
    • SLS

    Hi John ,

    Thanks for your feedback :slight_smile:

    I had a look in your db and seems some products have status draft. They should change status when updating the product in the sub sites.

    I would need to have a closer look on your files as I can't replicate this issue in my testing sites. Could you please provide ftp credentials? You can send them by replying to the email conversation with Jude.

    Make sure you provide:
    Host
    FTP username
    FTP password
    and Port (if required)

    When you send them please send a reply here so I can get notified faster :slight_smile:

    Thanks!

  • John
    • Site Builder, Child of Zeus

    Any updates here?

    We understand it's likely DB related as to why an incorrect number of products showing as indexed under Store Network Settings under NETWORK ADMIN, but we still do not show all indexed products in the store page located at http://www.frommyXXXXXXXyours.com/store.

    Currently, only 72 items show up on the store page, and we have 97 total products indexed so I'm guessing that all of those should be viewable on the shop page, correct? Thanks...

  • Jude
    • DEV MAN

    Hey John,

    Have forwarded the mail to Panos, thanks for sending that in. I want to understand if this is happening to any specific sub site or randomly to products across the network ? If its only a specific site, can you share the site ID / url here please ?

  • John
    • Site Builder, Child of Zeus

    Jude,
    We haven't delved that far into whether or not it's a specific site or all sites though it's unlikely to be the issue since all active stores w/products uploaded appear somewhere within the 4 store pages (3 sub-sites are Andy's Favorites, Grandmas Cuties, and M&M's Boutique).

    The only thing we know for certain is what's stated above in the previous post that items do not show on the store/shop page as they should:

    * We still do not show all indexed products in the store page located at http://www.frommyXXXXXXXyours.com/store (this is the MAIN SITE, not a sub-site)

    * Currently only 72 items show up on the store page but we have 97 total products, and there's still the issue of an incorrect product count in Store Network Settings under NETWORK ADMIN

  • John
    • Site Builder, Child of Zeus

    That's a manual count, we have a total of 97 actual products - the number of items that SHOW AS INDEXED in Store Network Settings under NETWORK ADMIN is higher, and incorrect, at 120 - however, only 72 items currently show up in the store page, some of which are actually duplicates, i.e. shown twice (www.frommyxxxxxxxyours.com/store)

  • John
    • Site Builder, Child of Zeus

    Panos,
    Looks good! Can you elaborate on the symbols issue mentioned in your reply, I'd like to be able to advise the site owner on what she was doing wrong on this (and when you say the issue has been fixed, is that to the point where symbols are now allowed & the product re-indexing will work even with symbols in product titles as we currently see?). Thanks for all your help on this, it's greatly appreciated...

    John

  • Panos
    • SLS

    Hey John ,

    It was a soft spot in MarketPress when updating the global products table, wasn't expecting this type of input I assume, but it should be updating properly now!

    I tried following after fix applied:
    1. Created new product with symbols on title and was automatically inserted in the global store

    2. Changed it's status from Public to Draft and back to Published again and each time it was updated

    3. I ran the indexer and products were indexed correctly. I also counted products in the sub sites to make sure :slight_smile:

    Please run some tests of your own and let me know if you notice any issues!

    Thanks!
    Panos

  • John
    • Site Builder, Child of Zeus

    Panos, been testing, adding/deleting over the last couple days and everything seems to show on the MAIN STORE page as it should (total of 131 items).

    I do have one question: when in the NETWORK ADMIN dashboard, why does the STORE NETWORK indexer still display a different quantity when compared to manually indexing (i.e. clicking the INDEX PRODUCTS button)?

    See the attached screenshot; is there a reason to be concerned about this, or is it database related and likely items that were previously removed/deleted that still show in the default quantity of products when you open STORE NETWORK page in NETWORK ADMIN? Thanks!

  • Panos
    • SLS

    Hi John,

    After the indexing is completed two numbers appear. The top one is the total count of rows in the database and the second one is the number of products found and indexed on all subsites.

    Please keep in mind that in front end only published products will be shown.

    Hope this helps!

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.