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

#   temporary no use of stock value

##

- **[Boudewijn](/forum/user/6864-boudewijn "View Boudewijn's Profile")**
- [![Boudewijn's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6864.jpg)](/forum/user/6864-boudewijn "View Boudewijn's Profile") Topic Author
- [ Offline](/forum/user/6864-boudewijn)

Less More

- Posts: 252
- Thank you received: 3
-
-
-
- [](http://www.dodowear.nl)
-

13 years 7 months ago [\#99027](#99027) by [Boudewijn](/forum/user/6864-boudewijn "View Boudewijn's Profile")  *[temporary no use of stock value](/forum/2-general-talk-about-hikashop/80400-temporary-no-use-of-stock-value#99027 "Hello, The stock of our webshop is feed from the POS-system. Now we need to do some work on this. We need to ad a second website to it So for that periode I don't want to use the stock information for the product. In that case everything can be ordered. No warrand for out of stock. Is this possible?")* was created by *[Boudewijn](/forum/user/6864-boudewijn "View Boudewijn's Profile")*

Hello,
The stock of our webshop is feed from the POS-system.
Now we need to do some work on this. We need to ad a second website to it
So for that periode I don't want to use the stock information for the product.
In that case everything can be ordered. No warrand for out of stock.
Is this possible?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwNDAwLXRlbXBvcmFyeS1uby11c2Utb2Ytc3RvY2stdmFsdWU/dG1wbD1tYXJrZG93bg==) 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: 86560
- Thank you received: 14307
-
-

13 years 7 months ago [\#99039](#99039) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[temporary no use of stock value](/forum/2-general-talk-about-hikashop/80400-temporary-no-use-of-stock-value#99039 "Hello, The stock of our webshop is feed from the POS-system. Now we need to do some work on this. We need to ad a second website to it So for that periode I don't want to use the stock information for the product. In that case everything can be ordered. No warrand for out of stock. Is this possible?")*

You can run a query in the database to have all the products with an unlimited quantity:

UPDATE #__hikashop_product SET product_quantity=-1 WHERE 1;

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

- **[Boudewijn](/forum/user/6864-boudewijn "View Boudewijn's Profile")**
- [![Boudewijn's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6864.jpg)](/forum/user/6864-boudewijn "View Boudewijn's Profile") Topic Author
- [ Offline](/forum/user/6864-boudewijn)

Less More

- Posts: 252
- Thank you received: 3
-
-
-
- [](http://www.dodowear.nl)
-

13 years 7 months ago [\#99154](#99154) by [Boudewijn](/forum/user/6864-boudewijn "View Boudewijn's Profile")  Replied by *[Boudewijn](/forum/user/6864-boudewijn "View Boudewijn's Profile")* on topic *[temporary no use of stock value](/forum/2-general-talk-about-hikashop/80400-temporary-no-use-of-stock-value#99154 "Hello, The stock of our webshop is feed from the POS-system. Now we need to do some work on this. We need to ad a second website to it So for that periode I don't want to use the stock information for the product. In that case everything can be ordered. No warrand for out of stock. Is this possible?")*

Ok thanks I will do that

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

- **[Boudewijn](/forum/user/6864-boudewijn "View Boudewijn's Profile")**
- [![Boudewijn's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6864.jpg)](/forum/user/6864-boudewijn "View Boudewijn's Profile") Topic Author
- [ Offline](/forum/user/6864-boudewijn)

Less More

- Posts: 252
- Thank you received: 3
-
-
-
- [](http://www.dodowear.nl)
-

13 years 7 months ago [\#99214](#99214) by [Boudewijn](/forum/user/6864-boudewijn "View Boudewijn's Profile")  Replied by *[Boudewijn](/forum/user/6864-boudewijn "View Boudewijn's Profile")* on topic *[temporary no use of stock value](/forum/2-general-talk-about-hikashop/80400-temporary-no-use-of-stock-value#99214 "Hello, The stock of our webshop is feed from the POS-system. Now we need to do some work on this. We need to ad a second website to it So for that periode I don't want to use the stock information for the product. In that case everything can be ordered. No warrand for out of stock. Is this possible?")*

Hello,
This has worked.
I have got the users also migrated.
Now I only need to have to add the orders.
Do I only need this table? jos_hikashop_order?

at this new database I have a few testing orders.
Those I don't need.
How can I replace this this best way?

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

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

13 years 7 months ago [\#99243](#99243) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[temporary no use of stock value](/forum/2-general-talk-about-hikashop/80400-temporary-no-use-of-stock-value#99243 "Hello, The stock of our webshop is feed from the POS-system. Now we need to do some work on this. We need to ad a second website to it So for that periode I don't want to use the stock information for the product. In that case everything can be ordered. No warrand for out of stock. Is this possible?")*

Hi,

You need:
- hikashop_order
- hikashop_order_product
- hikashop_address
- hikashop_history
- hikashop_file (if you have some downloadable files)

Do not forget to check your custom fields (hikashop_field) too.

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

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

- **[Boudewijn](/forum/user/6864-boudewijn "View Boudewijn's Profile")**
- [![Boudewijn's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6864.jpg)](/forum/user/6864-boudewijn "View Boudewijn's Profile") Topic Author
- [ Offline](/forum/user/6864-boudewijn)

Less More

- Posts: 252
- Thank you received: 3
-
-
-
- [](http://www.dodowear.nl)
-

13 years 7 months ago [\#99291](#99291) by [Boudewijn](/forum/user/6864-boudewijn "View Boudewijn's Profile")  Replied by *[Boudewijn](/forum/user/6864-boudewijn "View Boudewijn's Profile")* on topic *[temporary no use of stock value](/forum/2-general-talk-about-hikashop/80400-temporary-no-use-of-stock-value#99291 "Hello, The stock of our webshop is feed from the POS-system. Now we need to do some work on this. We need to ad a second website to it So for that periode I don't want to use the stock information for the product. In that case everything can be ordered. No warrand for out of stock. Is this possible?")*

Hello Jerome,
I got the tables.
Can I import/overwrite these table in the new database with a command?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwNDAwLXRlbXBvcmFyeS1uby11c2Utb2Ytc3RvY2stdmFsdWU/dG1wbD1tYXJrZG93bg==) 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: 86560
- Thank you received: 14307
-
-

13 years 7 months ago [\#99307](#99307) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[temporary no use of stock value](/forum/2-general-talk-about-hikashop/80400-temporary-no-use-of-stock-value#99307 "Hello, The stock of our webshop is feed from the POS-system. Now we need to do some work on this. We need to ad a second website to it So for that periode I don't want to use the stock information for the product. In that case everything can be ordered. No warrand for out of stock. Is this possible?")*

You have export and import tools in phpmyadmin for that.
Here is a tutorial for the export:
[ www.siteground.com/tutorials/php-mysql/mysql\_export.htm](http://www.siteground.com/tutorials/php-mysql/mysql_export.htm)

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

- **[Boudewijn](/forum/user/6864-boudewijn "View Boudewijn's Profile")**
- [![Boudewijn's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6864.jpg)](/forum/user/6864-boudewijn "View Boudewijn's Profile") Topic Author
- [ Offline](/forum/user/6864-boudewijn)

Less More

- Posts: 252
- Thank you received: 3
-
-
-
- [](http://www.dodowear.nl)
-

13 years 6 months ago [\#99591](#99591) by [Boudewijn](/forum/user/6864-boudewijn "View Boudewijn's Profile")  Replied by *[Boudewijn](/forum/user/6864-boudewijn "View Boudewijn's Profile")* on topic *[temporary no use of stock value](/forum/2-general-talk-about-hikashop/80400-temporary-no-use-of-stock-value#99591 "Hello, The stock of our webshop is feed from the POS-system. Now we need to do some work on this. We need to ad a second website to it So for that periode I don't want to use the stock information for the product. In that case everything can be ordered. No warrand for out of stock. Is this possible?")*

Hi,
I'm not very experienced with this part.
I have red the tutorial.
But when I try to import the tables is gives a message that it is missing cells or not the right numbering.
So it will not overwrite the existing table.
Can you give me a clue

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwNDAwLXRlbXBvcmFyeS1uby11c2Utb2Ytc3RvY2stdmFsdWU/dG1wbD1tYXJrZG93bg==) 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: 86560
- Thank you received: 14307
-
-

13 years 6 months ago [\#99674](#99674) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[temporary no use of stock value](/forum/2-general-talk-about-hikashop/80400-temporary-no-use-of-stock-value#99674 "Hello, The stock of our webshop is feed from the POS-system. Now we need to do some work on this. We need to ad a second website to it So for that periode I don't want to use the stock information for the product. In that case everything can be ordered. No warrand for out of stock. Is this possible?")*

Maybe that's because you are not using the same version of HikaShop on both websites ? Please make sure that it is the case or it won't work since the database structure is different between different versions of HikaShop.

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

- **[Boudewijn](/forum/user/6864-boudewijn "View Boudewijn's Profile")**
- [![Boudewijn's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6864.jpg)](/forum/user/6864-boudewijn "View Boudewijn's Profile") Topic Author
- [ Offline](/forum/user/6864-boudewijn)

Less More

- Posts: 252
- Thank you received: 3
-
-
-
- [](http://www.dodowear.nl)
-

13 years 6 months ago [\#99721](#99721) by [Boudewijn](/forum/user/6864-boudewijn "View Boudewijn's Profile")  Replied by *[Boudewijn](/forum/user/6864-boudewijn "View Boudewijn's Profile")* on topic *[temporary no use of stock value](/forum/2-general-talk-about-hikashop/80400-temporary-no-use-of-stock-value#99721 "Hello, The stock of our webshop is feed from the POS-system. Now we need to do some work on this. We need to ad a second website to it So for that periode I don't want to use the stock information for the product. In that case everything can be ordered. No warrand for out of stock. Is this possible?")*

Hello,
Both Hikashop have the same latest versions
For instance when I want to import table adress it gives this message

\#1054 - Unknown column 'address_vm_order_info_id' in 'field list'

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

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

13 years 6 months ago [\#99722](#99722) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[temporary no use of stock value](/forum/2-general-talk-about-hikashop/80400-temporary-no-use-of-stock-value#99722 "Hello, The stock of our webshop is feed from the POS-system. Now we need to do some work on this. We need to ad a second website to it So for that periode I don't want to use the stock information for the product. In that case everything can be ordered. No warrand for out of stock. Is this possible?")*

Hi,

"address_vm_order_info_id" is the column for the VirtueMart import.
You can remove it from the export and create the column in the new site (and delete the column later if no longer required).

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

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

- **[Boudewijn](/forum/user/6864-boudewijn "View Boudewijn's Profile")**
- [![Boudewijn's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6864.jpg)](/forum/user/6864-boudewijn "View Boudewijn's Profile") Topic Author
- [ Offline](/forum/user/6864-boudewijn)

Less More

- Posts: 252
- Thank you received: 3
-
-
-
- [](http://www.dodowear.nl)
-

13 years 6 months ago [\#99733](#99733) by [Boudewijn](/forum/user/6864-boudewijn "View Boudewijn's Profile")  Replied by *[Boudewijn](/forum/user/6864-boudewijn "View Boudewijn's Profile")* on topic *[temporary no use of stock value](/forum/2-general-talk-about-hikashop/80400-temporary-no-use-of-stock-value#99733 "Hello, The stock of our webshop is feed from the POS-system. Now we need to do some work on this. We need to ad a second website to it So for that periode I don't want to use the stock information for the product. In that case everything can be ordered. No warrand for out of stock. Is this possible?")*

Hi Jerome,
I think I got all.
Thanks.
Strange thing is that I miss the Name of the street in the adress of the Costumers.
I see also that the output file is empty.
Is this a known issue?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwNDAwLXRlbXBvcmFyeS1uby11c2Utb2Ytc3RvY2stdmFsdWU/dG1wbD1tYXJrZG93bg==) 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: 86560
- Thank you received: 14307
-
-

13 years 6 months ago [\#100054](#100054) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[temporary no use of stock value](/forum/2-general-talk-about-hikashop/80400-temporary-no-use-of-stock-value#100054 "Hello, The stock of our webshop is feed from the POS-system. Now we need to do some work on this. We need to ad a second website to it So for that periode I don't want to use the stock information for the product. In that case everything can be ordered. No warrand for out of stock. Is this possible?")*

That's not a known issue.

Normally, the address_street in HikaShop should be a concatenation of the address_1 and the address_2 fields of VM.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzgwNDAwLXRlbXBvcmFyeS1uby11c2Utb2Ytc3RvY2stdmFsdWU/dG1wbD1tYXJrZG93bg==) 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.084 seconds

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