-3

I have over 10,000 products so I won't be able to create a new web page for each one or add each one to my CMS individually.

Here's what I have:

  • A CMS that allows me to mass-upload using a CSV file
  • A cPanel GoDaddy Server with MySQL databases

Correct me if I'm wrong but is this the process for adding a product:

  1. Connect the CMS to the cPanel server
  2. Add products to the CMS using a CSV file
  3. Create a database in MySQL ont he GoDaddy server.
  4. Add PHP to website oriduct page to extract product information.

I'm confused as to how the product information is transferred from the CMS to the database in MySQL

Gottlieb Notschnabel
  • 9,408
  • 18
  • 74
  • 116
Grant9196
  • 139
  • 7
  • im confused to, what CMS are you using ? –  Jul 08 '15 at 22:57
  • its installed and working? it has a csv import option? –  Jul 08 '15 at 23:01
  • It is yes. But is what I said correct, is that the way it works? :S – Grant9196 Jul 08 '15 at 23:02
  • 1 makes no sense 2, ok yes. 3 no the CMS has already done that when you instlled it 4, no the CMS does that –  Jul 08 '15 at 23:04
  • 1. I need to download files from the CMs and install them into the GoDaddy cPanel server is wha tI was told to do. 4. I need to use PHP in the website for the website to interact with the server so it can extract all the product information and display it – Grant9196 Jul 08 '15 at 23:08
  • you say its installed and working above, all you should need to do is the import. –  Jul 08 '15 at 23:10
  • But I need to do something like this to connect the product page with the database of products so they can be displayed: [link](https://www.developphp.com/video/PHP/Product-Display-Page) – Grant9196 Jul 08 '15 at 23:14
  • no. that's the job of the CMS you installed - you should never have to write a line of code- that's why you installed this –  Jul 08 '15 at 23:15
  • since the CMS is installed onto the server, it doesn't make much sense to me that I don't need to use PHP to get the product information since it is the server I need to access. Just to clarify the CMS and the web hosting server are not the same company – Grant9196 Jul 08 '15 at 23:32
  • CMS = content management system, it is managing the content so you don't have to write code. thats the point of installing it. –  Jul 08 '15 at 23:38
  • @Grant9196 Then you should update/clarify your *Here's what I have* section! – Gottlieb Notschnabel Jul 08 '15 at 23:39
  • You still need to extract that content. You can't just assume the CMs and the website will sync without writing PHP to get them to talk – Grant9196 Jul 08 '15 at 23:44
  • the CMS **IS** the website –  Jul 08 '15 at 23:49
  • http://demo.cs-cart.com/ thats the website, its also the CMS. http://demo.cs-cart.com/admin.php?dispatch=auth.login_form&return_url=admin.php thats the admin end where you upload the csv, or add products by hand –  Jul 08 '15 at 23:50
  • So as long as the domain name is linked to the CMS and the CMS is linked to the hosting server, the products imported into the CMS using the CSV file will appear on each page? – Grant9196 Jul 09 '15 at 00:00
  • Why is it that when I go onto a website it will display the following url for a product: www.example.com/12345.php? I assume this is because they aren't using a CMS and are instead just creating MySQL databases – Grant9196 Jul 09 '15 at 00:04
  • 12345 could just be the id used in the db. doses that relate to this particular question - is this 'solved' ? –  Jul 09 '15 at 00:17
  • Dragon, just got everything sorted by my web host and it turns out you were completely wrong and I was right. Cheers m8 – Grant9196 Jul 12 '15 at 16:32

1 Answers1

2

When your CMS is fully installed and connected with your database -which should be the your regular setup- then simply import all your products from your CSV via the cs.cart import:

  1. In the administration panel, go to Administration > Import data > Products.
  2. Make sure the fields in your CSV file have the same names as the ones listed under the Products section on this page. Also check whether the values of the fields have the correct format. For more information about the correct format read the Imported fields format article.
  3. In the Import options section, specify the following settings [...]
  4. Click the Import button.
Gottlieb Notschnabel
  • 9,408
  • 18
  • 74
  • 116