[Skip to main content](#vessel-content)

#   Duplicate Products in Database - dont show on page

##

- **[davidla](/forum/user/6667-davidla "View davidla's Profile")**
- [![davidla's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6667-davidla "View davidla's Profile") Topic Author
- [ Offline](/forum/user/6667-davidla)

Less More

- Posts: 6
- Thank you received: 0
-
-

13 years 9 months ago [\#86269](#86269) by [davidla](/forum/user/6667-davidla "View davidla's Profile")  *[Duplicate Products in Database - dont show on page](/forum/2-general-talk-about-hikashop/77603-duplicate-products-in-database-dont-show-on-page#86269 "Hi, I have created a Site to which I recently added SH404ef and whilst I struggle to get that right I have another issue. Some of my products appear twise in the product browser, with the same ID. If I unpublish the product they both beome unpublished, so I know they are the same. Now when I browse the product in my site it lets me drill down via the menu see here:   www.allsortsofsweets.com.au/index.php/sour/product/listing.html  if you click the top middle product Ross's Soor Plooms, you will get a 404 error. How can this be?")* was created by *[davidla](/forum/user/6667-davidla "View davidla's Profile")*

Hi,
I have created a Site to which I recently added SH404ef and whilst I struggle to get that right I have another issue. Some of my products appear twise in the product browser, with the same ID. If I unpublish the product they both beome unpublished, so I know they are the same.
Now when I browse the product in my site it lets me drill down via the menu see here:
[ www.allsortsofsweets.com.au/index.php/sour/product/listing.html](http://www.allsortsofsweets.com.au/index.php/sour/product/listing.html)

if you click the top middle product Ross's Soor Plooms, you will get a 404 error. How can this be?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc3NjAzLWR1cGxpY2F0ZS1wcm9kdWN0cy1pbi1kYXRhYmFzZS1kb250LXNob3ctb24tcGFnZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")**
- [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile")
- [ Offline](/forum/user/4105-xavier)

Less More

- Posts: 13201
- Thank you received: 2322
-
-
-
- [](http://www.kidiweb.fr)
-

13 years 9 months ago [\#86384](#86384) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile")  Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Duplicate Products in Database - dont show on page](/forum/2-general-talk-about-hikashop/77603-duplicate-products-in-database-dont-show-on-page#86384 "Hi, I have created a Site to which I recently added SH404ef and whilst I struggle to get that right I have another issue. Some of my products appear twise in the product browser, with the same ID. If I unpublish the product they both beome unpublished, so I know they are the same. Now when I browse the product in my site it lets me drill down via the menu see here:   www.allsortsofsweets.com.au/index.php/sour/product/listing.html  if you click the top middle product Ross's Soor Plooms, you will get a 404 error. How can this be?")*

Hi,

Do you have edited any views ?
Are you sure that the products are twice in database ?

The 404 error append maybe because of the sh404sef configuration.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc3NjAzLWR1cGxpY2F0ZS1wcm9kdWN0cy1pbi1kYXRhYmFzZS1kb250LXNob3ctb24tcGFnZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[davidla](/forum/user/6667-davidla "View davidla's Profile")**
- [![davidla's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6667-davidla "View davidla's Profile") Topic Author
- [ Offline](/forum/user/6667-davidla)

Less More

- Posts: 6
- Thank you received: 0
-
-

13 years 9 months ago [\#86393](#86393) by [davidla](/forum/user/6667-davidla "View davidla's Profile")  Replied by *[davidla](/forum/user/6667-davidla "View davidla's Profile")* on topic *[Duplicate Products in Database - dont show on page](/forum/2-general-talk-about-hikashop/77603-duplicate-products-in-database-dont-show-on-page#86393 "Hi, I have created a Site to which I recently added SH404ef and whilst I struggle to get that right I have another issue. Some of my products appear twise in the product browser, with the same ID. If I unpublish the product they both beome unpublished, so I know they are the same. Now when I browse the product in my site it lets me drill down via the menu see here:   www.allsortsofsweets.com.au/index.php/sour/product/listing.html  if you click the top middle product Ross's Soor Plooms, you will get a 404 error. How can this be?")*

Not sure what view you are referring to.
The attached file shows an example of a duplicate product. I accept the link error may be a sh404 config issue and will take it up with them.

[ ![duplicate.jpg](/forum/attachment/8073) ](/forum/attachment/8073 "duplicate.jpg")

- [ ![duplicate.jpg](/forum/attachment/8073) ](/forum/attachment/8073 "duplicate.jpg") [ ](/forum/attachment/8073?download=1 "duplicate.jpg")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc3NjAzLWR1cGxpY2F0ZS1wcm9kdWN0cy1pbi1kYXRhYmFzZS1kb250LXNob3ctb24tcGFnZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")**
- [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile")
- [ Offline](/forum/user/4105-xavier)

Less More

- Posts: 13201
- Thank you received: 2322
-
-
-
- [](http://www.kidiweb.fr)
-

13 years 9 months ago [\#86419](#86419) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile")  Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Duplicate Products in Database - dont show on page](/forum/2-general-talk-about-hikashop/77603-duplicate-products-in-database-dont-show-on-page#86419 "Hi, I have created a Site to which I recently added SH404ef and whilst I struggle to get that right I have another issue. Some of my products appear twise in the product browser, with the same ID. If I unpublish the product they both beome unpublished, so I know they are the same. Now when I browse the product in my site it lets me drill down via the menu see here:   www.allsortsofsweets.com.au/index.php/sour/product/listing.html  if you click the top middle product Ross's Soor Plooms, you will get a 404 error. How can this be?")*

I don't really know how the product have been duplicated with the same id, it should not be possible.
Can you give us the steps used to duplicate this product ? (if you have duplicated it).

To remove one of this product, you can create a little script which will select all the products, check for duplicate IDs, get the duplicated product_id and product_order, and then delete the products from the table product where the product_id = ... AND product_order = ...

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc3NjAzLWR1cGxpY2F0ZS1wcm9kdWN0cy1pbi1kYXRhYmFzZS1kb250LXNob3ctb24tcGFnZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[davidla](/forum/user/6667-davidla "View davidla's Profile")**
- [![davidla's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6667-davidla "View davidla's Profile") Topic Author
- [ Offline](/forum/user/6667-davidla)

Less More

- Posts: 6
- Thank you received: 0
-
-

13 years 9 months ago [\#86512](#86512) by [davidla](/forum/user/6667-davidla "View davidla's Profile")  Replied by *[davidla](/forum/user/6667-davidla "View davidla's Profile")* on topic *[Duplicate Products in Database - dont show on page](/forum/2-general-talk-about-hikashop/77603-duplicate-products-in-database-dont-show-on-page#86512 "Hi, I have created a Site to which I recently added SH404ef and whilst I struggle to get that right I have another issue. Some of my products appear twise in the product browser, with the same ID. If I unpublish the product they both beome unpublished, so I know they are the same. Now when I browse the product in my site it lets me drill down via the menu see here:   www.allsortsofsweets.com.au/index.php/sour/product/listing.html  if you click the top middle product Ross's Soor Plooms, you will get a 404 error. How can this be?")*

The database only shows one item with the equivalent product_id (of course). This product has not been ordered yet so there are no orders. The problem appears to be in the display in hikashop only.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc3NjAzLWR1cGxpY2F0ZS1wcm9kdWN0cy1pbi1kYXRhYmFzZS1kb250LXNob3ctb24tcGFnZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[davidla](/forum/user/6667-davidla "View davidla's Profile")**
- [![davidla's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6667-davidla "View davidla's Profile") Topic Author
- [ Offline](/forum/user/6667-davidla)

Less More

- Posts: 6
- Thank you received: 0
-
-

13 years 9 months ago [\#86532](#86532) by [davidla](/forum/user/6667-davidla "View davidla's Profile")  Replied by *[davidla](/forum/user/6667-davidla "View davidla's Profile")* on topic *[Duplicate Products in Database - dont show on page](/forum/2-general-talk-about-hikashop/77603-duplicate-products-in-database-dont-show-on-page#86532 "Hi, I have created a Site to which I recently added SH404ef and whilst I struggle to get that right I have another issue. Some of my products appear twise in the product browser, with the same ID. If I unpublish the product they both beome unpublished, so I know they are the same. Now when I browse the product in my site it lets me drill down via the menu see here:   www.allsortsofsweets.com.au/index.php/sour/product/listing.html  if you click the top middle product Ross's Soor Plooms, you will get a 404 error. How can this be?")*

Further to this, the product shows as a single if I drill down through the product categories and only shows as duplicate if it is multiple categories. I assume then this is the design and it is in fact showing the same product for multiple categories. Maybe you need to display the category if you are going to do this, to avoid confusion. BTW what is the order field for?

David

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc3NjAzLWR1cGxpY2F0ZS1wcm9kdWN0cy1pbi1kYXRhYmFzZS1kb250LXNob3ctb24tcGFnZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")**
- [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile")
- [ Offline](/forum/user/4105-xavier)

Less More

- Posts: 13201
- Thank you received: 2322
-
-
-
- [](http://www.kidiweb.fr)
-

13 years 9 months ago [\#86661](#86661) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile")  Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Duplicate Products in Database - dont show on page](/forum/2-general-talk-about-hikashop/77603-duplicate-products-in-database-dont-show-on-page#86661 "Hi, I have created a Site to which I recently added SH404ef and whilst I struggle to get that right I have another issue. Some of my products appear twise in the product browser, with the same ID. If I unpublish the product they both beome unpublished, so I know they are the same. Now when I browse the product in my site it lets me drill down via the menu see here:   www.allsortsofsweets.com.au/index.php/sour/product/listing.html  if you click the top middle product Ross's Soor Plooms, you will get a 404 error. How can this be?")*

Had you edited the view "product / listing" in the backend template in HikaShop &gt; Display &gt; Views ?

The order field is for change the order of the products in the category, it can be useful in a frontend products listing, or if you use the "next - previous" buttons on a product page.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc3NjAzLWR1cGxpY2F0ZS1wcm9kdWN0cy1pbi1kYXRhYmFzZS1kb250LXNob3ctb24tcGFnZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[davidla](/forum/user/6667-davidla "View davidla's Profile")**
- [![davidla's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6667-davidla "View davidla's Profile") Topic Author
- [ Offline](/forum/user/6667-davidla)

Less More

- Posts: 6
- Thank you received: 0
-
-

13 years 9 months ago [\#86708](#86708) by [davidla](/forum/user/6667-davidla "View davidla's Profile")  Replied by *[davidla](/forum/user/6667-davidla "View davidla's Profile")* on topic *[Duplicate Products in Database - dont show on page](/forum/2-general-talk-about-hikashop/77603-duplicate-products-in-database-dont-show-on-page#86708 "Hi, I have created a Site to which I recently added SH404ef and whilst I struggle to get that right I have another issue. Some of my products appear twise in the product browser, with the same ID. If I unpublish the product they both beome unpublished, so I know they are the same. Now when I browse the product in my site it lets me drill down via the menu see here:   www.allsortsofsweets.com.au/index.php/sour/product/listing.html  if you click the top middle product Ross's Soor Plooms, you will get a 404 error. How can this be?")*

No definitely not.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc3NjAzLWR1cGxpY2F0ZS1wcm9kdWN0cy1pbi1kYXRhYmFzZS1kb250LXNob3ctb24tcGFnZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.061 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
