Hello,

Please see the related URL, select a Brand and hit Search. My client would like to be able to update the content in the Quantity column of the table every 2 hours. On the old site, built by another developer, my client updated quantities by uploading a .csv file via FTP. 

Questions:

1) What is the best way to automatically refresh/update the quantity column data and make it so that the client can easily send the new data? 

2) Should this be a mySQL table? I have access to the myPHP admin via Plesk but limited DB knowledge. Currently the table is an imported .csv. 

Note: Only the Quantity column will need to change automatically. New rows may be added manually as new products are offered.

Thank you in advance!

Update: I successfully created a table in mySQL, connected it to WP Table, and created a new table based on mySQL query. Everything worked except Advanced Filtering started acting weird so I went back to my manual table...

It seems like it might be easier to create a table based on a .csv URL. I could give the client FTP access to the directory and have them replace the entire .csv table every two hours.

I doubt this is the most elegant solution. I am trying to research how to populate the mySQL table quantity column dynamically but so far, no luck...

Could really use some guidance. 

I used the csv link option to build the table and this was my client's response: "Since our ERP system does not hold detail information as described when export, (entire table data) and when new part numbers are created I do not hold the detail information, is it possible you can create a mapping with your existing database with our part number to access the quantity?" 

Basically, they want my table to update the quantity by looking at a csv that only has part# and quantity columns, and map the correct quantity based on the part#. I have no idea how to do this. I just installed Visual Studio to see if I can figure it out... I am probably going to have to hire a SQL DB pro.