SQL queries for Prestashop 1.7.8
Budget: $30 – $250 USD
Hi all,
I am looking for a SQL programmer who can program specific SQL queries to be used in the Prestashop back-end to retrieve .csv files which are identical in columns/data as the Prestashop example .csv files to import the below into a new database.
Can you help me with this? Please read on.
Specific request:
Prestashop has the option to import the following through the back-end using sample csv files.
- Categories
- Products
- Customers
- Addresses
See attached those sample .csv files.
I want you to program an individual .SQL query to be used in the SQL manager of the back-end of Prestashop that gives an output identical to the columns required to fill the individual sample .csv files.
For example; 1 query for categories, 1 query for products, 1 for customers and 1 for addresses. A total of 4 queries.
Please note that the .sql query show give the exact information, formatted in the correct way (for example dates) and the columns should be in the right order (exactly as in the sample files).
I will provide access to a working back end to test the queries.
We would like to have this completed as soon as possible as for a skilled programmer this should be a fairly straightforward task!
Thanks
I am looking for a SQL programmer who can program specific SQL queries to be used in the Prestashop back-end to retrieve .csv files which are identical in columns/data as the Prestashop example .csv files to import the below into a new database.
Can you help me with this? Please read on.
Specific request:
Prestashop has the option to import the following through the back-end using sample csv files.
- Categories
- Products
- Customers
- Addresses
See attached those sample .csv files.
I want you to program an individual .SQL query to be used in the SQL manager of the back-end of Prestashop that gives an output identical to the columns required to fill the individual sample .csv files.
For example; 1 query for categories, 1 query for products, 1 for customers and 1 for addresses. A total of 4 queries.
Please note that the .sql query show give the exact information, formatted in the correct way (for example dates) and the columns should be in the right order (exactly as in the sample files).
I will provide access to a working back end to test the queries.
We would like to have this completed as soon as possible as for a skilled programmer this should be a fairly straightforward task!
Thanks