Error Duplicated Product Code.

  • Posts: 4
  • Thank you received: 0
8 years 11 months ago #222980

-- HikaShop version -- : 2.6.0
-- Joomla version -- : 3.4.5
-- PHP version -- : 5.6.16
-- Browser(s) name and version -- : All
-- Error-message(debug-mod must be tuned on) -- : Error

A product with the same code already exists

Error Saving

Message Error

A product with the same code already exists

Error Saving
Untilted2.png

how ever the product is not in the product list ?

the code is not showing when searched for ?
untilted.png

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
8 years 11 months ago #222982

Hi,

Change the "products" dropdown on the top right of the products listing to "all". That way you'll also see the variants on the products listing and if you search for the product code you'll probably find it used by a variant if it's not used by a product.

The following user(s) said Thank You: tpsgroups

Please Log in or Create an account to join the conversation.

  • Posts: 4
  • Thank you received: 0
8 years 11 months ago #223028

Thanks Nicolas
we have changed the selection to all
still not showing up and still saying product code already used.
we seem to have a few products that's happening to now.
Also we have noticed we have lost the Sales this month from the dash board.
It all started when the website crashed about 2 days ago.
Does this mean we have lost 5 weeks of work and would have to start all over again.
thanks

Attachments:
Last edit: 8 years 11 months ago by tpsgroups.

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
8 years 11 months ago #223253

Hi,

That's really strange.

then create a new mass action via the menu System>Mass action with a filter on the column "product_code" with your product code and an action "display the results". When you process it, that will display the entry with that product_code if any. If not, it really means that there is no product with such code.

Regarding the dashboard, it indeed seems that you removed all the orders data that you had.

But maybe both problems can be explained by your data being corrupt on your website. Try to repair your website tables, maybe that will help:
www.siteground.com/tutorials/phpmyadmin/...ptimize_database.htm
You can also try clicking on the "check database" button of the HikaShop configuration.

The following user(s) said Thank You: tpsgroups

Please Log in or Create an account to join the conversation.

  • Posts: 4
  • Thank you received: 0
8 years 11 months ago #223303

Thanks Nicolas

We deleted the whole site, uninstalled Joomla and hikashop.
and reinstalled the software and started again.
As the shop had to be back on line this morning
All working fine now

so no idear what happened.
Using MySgl workbench to back the Database up now so fingers crossed.

We will be buying the full version in few weeks.
as want to use the ACL facility to do a Trade customers price and Retail customer price.

Thanks

Please Log in or Create an account to join the conversation.

Time to create page: 0.064 seconds
Powered by Kunena Forum