|

CS-Cart 4.0.2 Released: Store Import, CDN Support, Widget Mode, More
Posted 21 October 2013 - 03:19 PM #101
I have a big problem with an import csv file. i can t import the pictures and if i import a file 5 times, i have 5 identical products. It is a bug from me? or is a general bug?
Can you help me
thanks
___________
cs-art 2.2.4 is the best
Posted 22 October 2013 - 12:57 AM #102
EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.
Posted 22 October 2013 - 08:11 PM #104
can you import images without problem in 4.0.2 (looks like it has more bugs than 4.0.1)?
I followed "bug instructions"... and it keeps saying:
Error Please specify the images directory within the store root directory. Put the images to import in this directory.
var/exim/backup/images/
I have images in this folder, and in my import csv I have tested with absolute, relative and "only file" name path. NOTHING works.
-----
Another issue is that if I import my own "product id" number after export (or during import) it does not respect my codes, I mean If I import product is: 501, 502, 503 . It gives me 1, 2, 3.
Any idea how to resolve these issues?
Posted 22 October 2013 - 09:34 PM #105
Are the file permissions correct?Error Please specify the images directory within the store root directory. Put the images to import in this directory.
var/exim/backup/images/
One Step Checkout Addon - The ultimate checkout experience
Best CS-Cart SEO addon - CS-Cart SEO Ultimate Addon
PM for 365-day support and custom development service
Posted 23 October 2013 - 05:06 AM #106
EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.
Posted 23 October 2013 - 07:17 AM #107
Are the file permissions correct?
It is installed on local enviroment, never had this problem before 4.0.2.
I noticed that by default var/exim/backup/images/ did not exist (not sure if it is normal)
So I created test product with image and exported, so this folder was created. Afterwords I placed new images there and tried new import. Still gives the same error.
Another strange thing. If I try to change the path in the image import options it does not let me and change back to the default path var/exim/backup/images/
Posted 23 October 2013 - 07:30 AM #108
Unknown (or unsupported) fields are ignored on import. So if you have a column named "Product id" it will probably be ignored. Everything is done by product_code (and product_code is not unique in the DB).
One moment... The field Product id is one of the default import fields how can it be unknown? Moreover this is a key field in Product combination import.
The normal procedure was to assign product id (besides product code) in the Product import table and use the same product id in order to assign specific combination codes in the Product combination table...
So I would like to keep my product id during import at least, otherwise it will be impossible to import combination codes correct.
Or something is changed in this regards in 4.0.2?
Posted 23 October 2013 - 05:29 PM #109
A product_id is an internal identifier and should never be used in marketing or external links. One should always use the product code.
You would have to make changes to the import area to:
- check if the product exists
- if it does, do an update, if not, do an insert (or you might get away with a replace)
EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.
Posted 23 October 2013 - 05:45 PM #110
I beg to differ.. For an import, "Product code" is the only required field and as stated above any column named 'Product id" will probably be ignored/excluded.
A product_id is an internal identifier and should never be used in marketing or external links. One should always use the product code.
You would have to make changes to the import area to:
- check if the product exists
- if it does, do an update, if not, do an insert (or you might get away with a replace)
Tony, I was wondering, do you know how to link to a product without using the product ID or seo url? These links can be very handy because they link to the language the customer used the shop last in.
When life hands you lemons, bring on the Tequila baby!
Posted 23 October 2013 - 08:55 PM #111
I know, some of you are laughing at me and probably already knew that. My guess is there is someone else who found out the hard way.
Now I'm off to figure out all the other changes I made and lost.
By the way, I could not post here using Firefox 24, Chrome 30 or IE9. I finally had to click on the "Reply to this Topic" to be able to post...if this even post. Not to mention the page takes FOREVER to load the bottom section. Are there some bugs going on in the forum?
Jim
Posted 23 October 2013 - 10:11 PM #112
Pretty easy to do a controller that will translate a product code to a product id. You can look at the free "remote_checkout" script I posted (and updated for V4). It uses a product_code as the argument. Note that unless Localization is being used, things will still be in CART_LANGUAGE unless otherwise set in the URL (I.e. &sl=[language_code]).do you know how to link to a product without using the product ID
EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.
Posted 23 October 2013 - 10:15 PM #113
I believe (from the posts Imax made) that "Data Actualization" brings in orders and customers only and updates them to be the same as the imported store. But that's a guess.
EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.
Posted 23 October 2013 - 10:25 PM #114
Posted 23 October 2013 - 10:34 PM #115
Jim
Posted 23 October 2013 - 11:05 PM #116
From Tools post it sounds like I should count my blessings that it didn't shut down my live site. I'm glad I am testing on a site that is not my primary.
What you need to do is edit your table_replacement.php file.. Located in /app/addons/store_import/schemas/store_import/
Need to remove all the // in front of everything except the following. Then the import will only bring across the following.. What I had to do..
//'new_orders',
//'order_data',
//'order_details',
//'order_docs',
//'order_transactions',
//'orders',
//'user_data',
//'user_profiles',
//'user_session_products',
//'users',
This will bring across only users and orders.. You can select exactly what you want to be imported.
Elkhorn Graphics LLC
Cs-Cart 4.11.2
Posted 24 October 2013 - 02:42 AM #117
Jim
Posted 24 October 2013 - 03:07 AM #118
Hey CarStickersDecals, did you edit this file before you did the import or after you did the initial? I will have to try this on one of our other sites.
I originally did the complete import.. And after I did the same as you and did it all again and blew all my settings and configuration, I figured out that I could control what tables got over written.. Its a lot easier having that control.. Makes for a quick update into the new system.
Elkhorn Graphics LLC
Cs-Cart 4.11.2
Posted 24 October 2013 - 01:43 PM #119
Jim, No, I doubt anyone is laughing. There are bugs in V4.0.2 store iimport (probably why V4.0.3 is on such a short horizon) and the documentation is terrible and does not describe what really happens. A good technical writer is needed for all areas of the cart (primarily admin) that can write good "theory of operation" type descriptions for actions taken and what the expected results should be.
I believe (from the posts Imax made) that "Data Actualization" brings in orders and customers only and updates them to be the same as the imported store. But that's a guess.
Tony,
The data Actualization does bring in the new orders, customers and a lot more. The addons were reset to default, the store name reset to default , the language I had to go and set the country . Design was not touched, mine stayed intact . I agree with you many bugs to be fixed, just take a look at the bug tracker.
Joe
CS-Cart 4.11.5
Posted 24 October 2013 - 06:43 PM #120
They are (and I don't think they should) bringing across 3rd party addon tables in V4. This causes all sorts of problems since there are things like company_id and lang_code that would then be invalid.
EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.