|
Paul
|
Posted Tue 30 Apr 2013
|
|
Group: Administrators
Last Active: Tue 10 Sep 2024
Posts: 807,
Visits: 2,748
|
Firstly, whatever you do, back up your db first, so if anything goes wrong, you can restore it. This is good advice even if you're just having a big manual session of adding or editing products, and is certainly advisable when using alpha software like this for direct modification.
It is possible to use a spreadsheet to add new products to an existing site, and update existing items too. There are options for this (see screenshot).
There is a saved export in the back end (database admin) that can export products; not 100% sure about options products though.
--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.
If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb
2.png
(6 views,
38.11 KB)
|
|
|
|
|
pcotgrove
|
Posted Mon 29 Apr 2013
|
|
Group: Forum Members
Last Active: Sat 18 May 2013
Posts: 0,
Visits: 57
|
Hi
Have downloaded but need to sort out a new database to test with unless you can tell me if I can use this tool to add - I am asking if my testing with a new product or two will completely the zero the product list that already exists in the DB or whether it will just append the new products?
Also is there a way to export the product data at all? Maybe in a similar format so that I can maintain a master product file?
|
|
|
|
|
Paul
|
Posted Mon 29 Apr 2013
|
|
Group: Administrators
Last Active: Tue 10 Sep 2024
Posts: 807,
Visits: 2,748
|
|
|
|
|
|
Paul
|
Posted Mon 29 Apr 2013
|
|
Group: Administrators
Last Active: Tue 10 Sep 2024
Posts: 807,
Visits: 2,748
|
I'm compiling a version now... need to do a few basic tests, but if it runs ok should have a zip in next 2-3 hours.
--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.
If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb
|
|
|
|
|
pcotgrove
|
Posted Fri 26 Apr 2013
|
|
Group: Forum Members
Last Active: Sat 18 May 2013
Posts: 0,
Visits: 57
|
Hi
Has there been any updates to the data tool v2 beta that I have had a look at previosuly? As my product portfolio grows its taking more and more time to manage
Thanks
Paul
|
|
|
|
|
Paul
|
Posted Fri 5 Apr 2013
|
|
Group: Administrators
Last Active: Tue 10 Sep 2024
Posts: 807,
Visits: 2,748
|
Getting data on manually would be a very complex task - product info for example is spread over multiple tables, because the language specific text parts are in the language elements table while the product stubs are in the products table - then there are versions, and product-category links, cat-cat links and so on.
The 1.4 db setup script would create a 1.4 db you can run data into that with the older data tool, then run the upgrade process scripts. Alternatively you could download an older CactuShop access db (from www.cactushop.com), run your data into that with the older data tool, and then use the new Kartris data tool to copy data from that to your SQL db (I've used the CactuShop import part of it so pretty sure that part is working).
We're working on the v2 db but it's going to take some time to get this all done and tested.
--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.
If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb
|
|
|
|
|
pcotgrove
|
Posted Fri 5 Apr 2013
|
|
Group: Forum Members
Last Active: Sat 18 May 2013
Posts: 0,
Visits: 57
|
Hi Paul
Did anyone get the chance to look at the alpha version of the data tool yet? Your suggestion re the 1.4 database is a non starter for me as I only have a v2 environment
I am well versed with SQL so if there is a list of tables that I need to make sure are populated could you let me know as I can either use BCP or 2008 DTS equiv to get the data in - just need to know what tables need to be populated for a complete product to be valid on the site
Thanks
|
|
|
|
|
Paul
|
Posted Wed 3 Apr 2013
|
|
Group: Administrators
Last Active: Tue 10 Sep 2024
Posts: 807,
Visits: 2,748
|
yes... i will test PM now and see what the problem is
--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.
If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb
|
|
|
|
|
pcotgrove
|
Posted Wed 3 Apr 2013
|
|
Group: Forum Members
Last Active: Sat 18 May 2013
Posts: 0,
Visits: 57
|
Had to email you Paul as the PM kept producing an error
Have you got it?
|
|
|
|
|
Paul
|
Posted Wed 3 Apr 2013
|
|
Group: Administrators
Last Active: Tue 10 Sep 2024
Posts: 807,
Visits: 2,748
|
We've been totally rebuilding the DT for 2.0; if you can PM me with your email address I can send you an alpha version.
As well as code changes to handle 2.0 changes, we've also overhauled the interface so it runs largely in a resizable window. We also save connections in a connections manager, so you don't have to rekey data if running in multiple times, and the interface has been simplified.
--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.
If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb
|
|
|
|