New member here. Been in IT forever, just new to CS Cart. Installed latest version on a Linux Red Hat VM.
Importing Users from old system. Using the import wizard at :
[our VM IP address]/admin.php?dispatch=exim.import§ion=users
Via MySqlWorkbench, I verified there is no actual Vendor table.
All are stored in the Users table and “User type”, char 1, is a “C” or “V” stating that the user is a customer or vendor.
So for the import, can someone verify what this Vendor value is supposed to be in the import file. It is required. Is it:
• 0 / 1
• Yes / No
• Vendor Name
• Other?
Thanks
Hi!
The
field is the vendor’s company name and should be the same as the company field from the cscart_companies table.
Thanks for your reply. There is also a Company field in the User import. I presume these would are redundant. Under what circumstances would Company and Vendor be different for a User record?
Ah, I see in MySqlWorkbench. The Company table is where the Vendors go on import. So I need to import those first before users.
Related, I do not see a Company import. I do have a list of companies from our old system, want to get those into the formal CS Cart table. I know I can enter them via MySqlWorkbench but would rather have a safe way from the UI. IOW, do these records get created when one imports a vendor or user? Thanks
The Company field is related to the default Company user profile field and has nothing to do with the vendor.
For sure.
On the import page, import of the vendors can be found on the Vendors tab:
Thanks. It would really help if you guys put this info in the online documentation. No idea what these fields are just looking at the import pages. Better would be to put this exact text on “Company” and all other fields on the import page.
I am importing data and images onto a RHEL server running the latest version.
For Vendors, it does not allow me to import the Company ID.
My images directory structure depends on having the ID so I do not have to load all images in a single folder.
Even if modern Linux systems allow it, it affects performance.
At least that is my assumption, please correct if wrong.
I read all the User docs on the subject. This doc for products:
https://docs.cs-cart.com/latest/user_guide/manage_products/import_export/product_image_import.html
Mentions using the same folder as the import wizard, i.e. using the private files.
I have hundreds of Vendors (Companies) and thousands of Product images. The import wizard at
[my server]/admin.php?dispatch=exim.import§ion=vendors
says to import all my images to “exim/backup/images/” by leaving off the path in the field “Logo for the customer area”
I see when images are added via the UI that CS Cart does use a folder structure with the company id, which is the proper way to do it. IOW, quoting the doc above:
Public files are located in images/companies/[number].
How can I accomplish loading my images into said public structure when I am not allowed to import my Company id?
The new ID CS Cart generates is not the same as the ID I already have for each Vendor record.
I did look at the API and the “Create a Vendor” call does the same thing, it will not allow me to pass in the actual ID.
Any guidance appreciated.
Thanks
Thanks for the feedback. I’ve created a new task for the tech writer.
If you run the import from the admin panel rather than the vendor panel, you can put all the images directly into the var/files/ folder (without specifying the company ID in the path), and they will be imported correctly.
Yes, after reading the docs and experimenting, I found that if I put images in “exim/backup/images/” and leave the path blank, for vendor import it does link up the images. I copied all images into there and all attachments into “exim/backup/attachments/” via Storage / File Manager. I am storing old IDs into unused fields on the import in case I need to run any database scripts post import to massage the data. BTW, your File Manager is awesome, fast and intuitive!
I have successfully imported vendors (companies) and users. The issue is when importing products, they can have more than one attached document and image. For the product import, the only columns I see are “files” and "Detailed image’. How can I assign multiple files and images to a single product on import?
Do I have to run a script in the database post import to accomplish this? Hope not 