WOOCOMMERCE PRODUCT DATABASE UPDATE BY REMOTE USER
We have an eshop built with WooCommerce and we want an application with which one can upload products to the eshop, without having to be in the WooCommerce management program (remotly). This remote user is not a member of our company, he is a merchant who will sell his products through our eshop. The remote user should complete for every product certain fields.
We think of two ways (open to discuss any other way one can recommend us).
The first way is for the remote User to upload the Products directly in the Database of our Woo eshop. The question is how to ensure that the remote User will update all the required (mandatory) fields of every product.
The second way is for the remote User to “upload” all the data for each product in an Application. When he completes, we will export the uploaded data in CSV format and then the data will be uploaded to our eshop (CSV in WooCommerce). Obviously in this scenario the upload of the photos of the products will have to be managed differently.
In the application we will give access to the user, giving him the username and password to enter the application (or the Woo backoffice) remotely.
The SKU number of each product is not set by the User but by us. We would like it to come out automatically in ascending order, starting with the number 6000000. The next number to be 6000001 etc.
For each User we create a new entry into "Categories", which is unique for the specific User and for the specific case (meaning next time we will provide a new entry for him). All products the remote User will upload will get this Category.
FIELDS AUTOMATICALLY COMPLETED FOR EACH PRODUCT
The following fields for each product will be updated automatically, without the User having to fill them in (not nesecary for the remote user even to see those fields).
1. Visibility in catalog (RESULT: hidden for all products)
2. Tax status (RESULT: taxable for all products)
3. Low stock amount (RESULT: 2 (prefix quantity))
4. Allow customer reviews? (RESULT: 1)
5. In stock (RESULT: 1)
6. Backorders allowed? (RESULT: 0)
7. Sold individually? (RESULT: 0)
In the above fields, some more may be added so that the necessary information is not missing from the products, when they are uploaded to the eshop database.
FIELDS COMPLETED BY THE USER
For each product, the remote user must fill in the following fields:
1. Name (up to 100 characters, with spaces) (mandatory)
2. Short description (up to 300 characters, with spaces) (mandatory)
3. Description (up to 1500 characters, with spaces) (mandatory)
4. Tax class (the User chooses between the specific "Tax class" that we have in the eshop) (mandatory)
5. Regular price (mandatory)
6. Sale price (mandatory)
7. Stock (mandatory)
8. Weight (kg) (mandatory)
9. Length (cm)
10. Width (cm)
11. Height (cm)
Products that have a different type (TYPE) are uploaded to the eshop, whether they are simple (SIMPLE) or have variations (VARIATION).
That means that the remote User will choose each product TYPE (SIMPLE or VARIATION).
If he chooses VARIATION, he will then have to choose for each type of Attributes and put a quantity. Common attributes are shoe size, size (except shoes) and color (except shoes).
When it has VARIATION, the quantity is included in each different combination.
For each product, the remote User can upload up to 3 photos. Each photo must be of type jpg, png, bmp with a minimum size of _________ and a maximum size of ____________ or alternatively dimensions ___ X ___