[Skip to main content](#vessel-content) # Can't update product Information ## - **[dan c.](/forum/user/2877-dan-c "View dan c.'s Profile")** - [![dan c.'s Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar2877.jpg)](/forum/user/2877-dan-c "View dan c.'s Profile") Topic Author - [ Offline](/forum/user/2877-dan-c) Less More - Posts: 43 - Thank you received: 0 - - 15 years 4 months ago [\#19198](#19198) by [dan c.](/forum/user/2877-dan-c "View dan c.'s Profile") *[Can't update product Information](/forum/3-bug-report/19198-cant-update-product-information#19198 "I recently purchased the Essential commercial version, after upgrade I have noticed two things not working properly for some reason or another. 1) When i go to a product I have already created and try to update it and save. I keep receiving this message "A product with the same code already exists Error Saving". I have even tried checking off a product and clicking edit, make adjustments & it gives me this error. 2) One of the main features that sold me was the option to have Payment of orders not paid immediately. However after purchasing and enabling this feature, it didn't stop me from being directed to PayPal. If the checkout method is removed from the workflow, then how can we send them an updated invoice with the payment link? I'm not as tech savvy as most, so until a shipping module is available I was wanting to just receive orders from customers, apply shipping charges, then send them an updated invoice with the link to checkout. I didn't see how to include a payment link in the invoice. Any and all help is greatly appreciated.")* was created by *[dan c.](/forum/user/2877-dan-c "View dan c.'s Profile")* I recently purchased the Essential commercial version, after upgrade I have noticed two things not working properly for some reason or another. 1) When i go to a product I have already created and try to update it and save. I keep receiving this message "A product with the same code already exists Error Saving". I have even tried checking off a product and clicking edit, make adjustments & it gives me this error. 2) One of the main features that sold me was the option to have Payment of orders not paid immediately. However after purchasing and enabling this feature, it didn't stop me from being directed to PayPal. If the checkout method is removed from the workflow, then how can we send them an updated invoice with the payment link? I'm not as tech savvy as most, so until a shipping module is available I was wanting to just receive orders from customers, apply shipping charges, then send them an updated invoice with the link to checkout. I didn't see how to include a payment link in the invoice. Any and all help is greatly appreciated. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xOTE5OC1jYW50LXVwZGF0ZS1wcm9kdWN0LWluZm9ybWF0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 15 years 4 months ago [\#19200](#19200) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Can't update product Information](/forum/3-bug-report/19198-cant-update-product-information#19200 "I recently purchased the Essential commercial version, after upgrade I have noticed two things not working properly for some reason or another. 1) When i go to a product I have already created and try to update it and save. I keep receiving this message "A product with the same code already exists Error Saving". I have even tried checking off a product and clicking edit, make adjustments & it gives me this error. 2) One of the main features that sold me was the option to have Payment of orders not paid immediately. However after purchasing and enabling this feature, it didn't stop me from being directed to PayPal. If the checkout method is removed from the workflow, then how can we send them an updated invoice with the payment link? I'm not as tech savvy as most, so until a shipping module is available I was wanting to just receive orders from customers, apply shipping charges, then send them an updated invoice with the link to checkout. I didn't see how to include a payment link in the invoice. Any and all help is greatly appreciated.")* 1. That means that a product with the same product code exists. You should change the product code of the product so that it works properly. You can try to activate the debug mode of the joomla configuration to see a better error message which should help us understand better the problem. 2. You can indeed remove the payment view of the checkout so that your users are not redirected to paypal. Then, when you edit the order and set the shipping, you can click on the send notification to send an email to the user. However, the notification for shipping method update is empty so you would have to write the email yourself each time. Instead, if you want the whole information of the order you can just change the status of the order and the notification email will contain it. You should add a link to the user's listing of orders where he will be able to click on the pay button for his order. You can get such a link by creating a menu of the type hikashop order listing via the joomla menu manager. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xOTE5OC1jYW50LXVwZGF0ZS1wcm9kdWN0LWluZm9ybWF0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[dan c.](/forum/user/2877-dan-c "View dan c.'s Profile")** - [![dan c.'s Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar2877.jpg)](/forum/user/2877-dan-c "View dan c.'s Profile") Topic Author - [ Offline](/forum/user/2877-dan-c) Less More - Posts: 43 - Thank you received: 0 - - 15 years 4 months ago - 15 years 4 months ago [\#19211](#19211) by [dan c.](/forum/user/2877-dan-c "View dan c.'s Profile") Replied by *[dan c.](/forum/user/2877-dan-c "View dan c.'s Profile")* on topic *[Re: Can't update product Information](/forum/3-bug-report/19198-cant-update-product-information#19211 "I recently purchased the Essential commercial version, after upgrade I have noticed two things not working properly for some reason or another. 1) When i go to a product I have already created and try to update it and save. I keep receiving this message "A product with the same code already exists Error Saving". I have even tried checking off a product and clicking edit, make adjustments & it gives me this error. 2) One of the main features that sold me was the option to have Payment of orders not paid immediately. However after purchasing and enabling this feature, it didn't stop me from being directed to PayPal. If the checkout method is removed from the workflow, then how can we send them an updated invoice with the payment link? I'm not as tech savvy as most, so until a shipping module is available I was wanting to just receive orders from customers, apply shipping charges, then send them an updated invoice with the link to checkout. I didn't see how to include a payment link in the invoice. Any and all help is greatly appreciated.")* **nicolas wrote:** > 1\. That means that a product with the same product code exists. You should change the product code of the product so that it works properly. You can try to activate the debug mode of the joomla configuration to see a better error message which should help us understand better the problem. > > > 2\. You can indeed remove the payment view of the checkout so that your users are not redirected to paypal. Then, when you edit the order and set the shipping, you can click on the send notification to send an email to the user. However, the notification for shipping method update is empty so you would have to write the email yourself each time. Instead, if you want the whole information of the order you can just change the status of the order and the notification email will contain it. You should add a link to the user's listing of orders where he will be able to click on the pay button for his order. You can get such a link by creating a menu of the type hikashop order listing via the joomla menu manager. 1. so in order to update some product info I have to create a second item similar to my old one? I can't just update some info and save it? I tried removing the code and saving after making adjustments and it just gave me a reply that said "Error." ? I'm not sure what's wrong. Edit: I ran in debug mode here is the results, hope this helps: > JDatabaseMySQL::query: 1054 - Unknown column 'customtext\_167\_17\_53\_48' in 'field list' SQL=UPDATE `jos\_hikashop\_product` SET `product\_name`='Gilbert 1929 Alarm Clock',`product\_url`='',`product\_meta\_description`='',`product\_keywords`='Gilbert 1929 Alarm Clock',`product\_code`='Gilbert\_1929\_Alarm\_Clock',`product\_tax\_id`='24',`product\_sale\_start`='',`product\_sale\_end`='',`product\_quantity`='1',`product\_min\_per\_order`='0',`product\_max\_per\_order`='1',`product\_weight`='15.000',`product\_weight\_unit`='lb',`product\_length`='0.000',`product\_width`='0.000',`product\_dimension\_unit`='in',`product\_height`='0.000',`product\_published`='1',`product\_type`='main',`customtext\_167\_17\_53\_48`='',`product\_description`='' WHERE product\_id='94' 2. I understand and know now how to make that happen, thanks for clarifying. Last edit: 15 years 4 months ago by [dan c.](/forum/user/2877-dan-c "View dan c.'s Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xOTE5OC1jYW50LXVwZGF0ZS1wcm9kdWN0LWluZm9ybWF0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[dan c.](/forum/user/2877-dan-c "View dan c.'s Profile")** - [![dan c.'s Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar2877.jpg)](/forum/user/2877-dan-c "View dan c.'s Profile") Topic Author - [ Offline](/forum/user/2877-dan-c) Less More - Posts: 43 - Thank you received: 0 - - 15 years 4 months ago [\#19212](#19212) by [dan c.](/forum/user/2877-dan-c "View dan c.'s Profile") Replied by *[dan c.](/forum/user/2877-dan-c "View dan c.'s Profile")* on topic *[Re: Can't update product Information](/forum/3-bug-report/19198-cant-update-product-information#19212 "I recently purchased the Essential commercial version, after upgrade I have noticed two things not working properly for some reason or another. 1) When i go to a product I have already created and try to update it and save. I keep receiving this message "A product with the same code already exists Error Saving". I have even tried checking off a product and clicking edit, make adjustments & it gives me this error. 2) One of the main features that sold me was the option to have Payment of orders not paid immediately. However after purchasing and enabling this feature, it didn't stop me from being directed to PayPal. If the checkout method is removed from the workflow, then how can we send them an updated invoice with the payment link? I'm not as tech savvy as most, so until a shipping module is available I was wanting to just receive orders from customers, apply shipping charges, then send them an updated invoice with the link to checkout. I didn't see how to include a payment link in the invoice. Any and all help is greatly appreciated.")* I figured out what it was, I made a custom field and I guess i did something wrong when setting it up. I disabled it now I'm able to save my updated products with no problem. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xOTE5OC1jYW50LXVwZGF0ZS1wcm9kdWN0LWluZm9ybWF0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & 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.051 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)