Ecommerce : wich I can use ?

[Silvio.Falconi]

someone tried to communicate with Woocommerce ( wordpress) from an application created in fwh?

someone tried to communicate with PrestaShop from an application created in fwh?

thanks in advance

[Marc Venken]

Silvio,

I use FW to manage all productdata data in Prestashop. I generate the catalog with FW (make groups, select products for groups, add pics to products....)
You know that you easily will have 200/300.000 product data's available, but with offline (FW) managemend I only upload final selected products.

You can easy Xbrowse all Presta data, but for product import, I use a 3the party import Mod for Presta. You only have to create a exel file an dthe mod do the rest.
Mutch more easy that putting data into the presta's files.

Of cource, some data can be accessed with FW for easy datachange like names, groups, ....

The main benifid is that I can import ALL my data from ALL my manufacturers in 1 massive FW system and generated the presta groups offline. Much more speed and control
for putting the right pics to the right products/ colors..

The browse :

Left Top Brw : Menu system for onlline Presta
Mid Top BRW : Available Pics for the product
Right Top BRW : The Product have a matching color (trouwsers)
Mid Brw : Selections for that group that will go online
Bottom Brw : Possible selection for a product to add to the group.

There is more, but that depends on what you want to do.

[Silvio.Falconi]

I have all with Dbfs
Exist a class to convert dbf into Prestashop Files and the functions to migrate to Prestashop and from Prestashop to fivewin (dbf) ?

I Used allways Woocommerce I not Know Prestashop
I have my server to install Prestashop

[Marc Venken]

No, No class as far as I know.

Marc

[Carlos Mora]

Silvio,
the WooCommerce API doesn't look to hard to learn.
https://woocommerce.github.io/woocommer ... -api-docs/

With a little bit of Curl you are done

[Silvio.Falconi]

I Know some api of woocommerce because I made 4 years ago a a plugin
http://www.eoeo.it/portfolio/woocommerce-italia/ for Italian Commerce because on woocommerce need some italian fiscal features. Woocommerce is born on Australia. it's for english ecommerce , then is extended to other states

[Silvio.Falconi]

I'm thinking...
many years ago I collaborated on the creation of a store created with the ASP language.

 the program used the MDB archives.

I do not think it is difficult to create a simple online store on the line of the one created in Asp, perhaps in Php and Sql language.

 the program was created in simple modules that can be connected and linked to each other in a simple way.
 the page always had the same tabular structure of three columns then a header and a footer. I alone would take a long time but if we were many we could share the job.

I understand that one prefers to use programs already made like PrestaShop or WooCommerce but as I understand it is very difficult to talk with these programs.

 The main problem is the archives: we use and we have always used the dbfs we have applications all with the dbfs files but for the web one needs sql, Ms - Sql, Mysql.

Then the connection between fwh and the web is difficult.

When I used Asp and that program of shop-online I had created a program in fwh and downloaded the Mdb files from my domain and I could go to edit them, print, insert the products and then I could upload them to the domain.

There were no problems with Json, various activations, Rest Api or other incredible codes that you had to study.

I saw work by Linares fweb's work but I did not understand anything.

Then I saw another work by Lalin, but maybe I had problems with understanding this too.

So I gave up.

[Carlos Mora]

Hi Silvio,

The main problem is the archives: we use and we have always used the dbfs we have applications all with the dbfs files but for the web one needs sql, Ms - Sql, Mysql.

IMHO it is not the right approach. Take a look at the link i posted regarding WooCommerce API, that's the way desktop and external programs should use to push and pull information. Besides they are using SQL for their storage needs, there are some internal mechanisms that pull some triggers related to the operation.

Then the connection between fwh and the web is difficult.

FWH and Harbour provide all the tools you may need. There are lots of SQL functions and the expertise in the forum has grown exponentially, nowadays SQL is not a monster anymore.

The WooCommerce API is really easy. You may even update the database without proggraming, just using the command line:

Code: Select all  Expand view

curl -X POST https://example.com/wp-json/wc/v2/products \
    -u consumer_key:consumer_secret \
    -H "Content-Type: application/json" \
    -d '{
  "name": "Premium Quality",
  "type": "simple",
  "regular_price": "21.99",
  "description": "Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Vestibulum tortor quam, feugiat vitae, ultricies eget, tempor sit amet, ante. Donec eu libero sit amet quam egestas semper. Aenean ultricies mi vitae est. Mauris placerat eleifend leo.",
  "short_description": "Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.",
  "categories": [
    {
      "id": 9
    },
    {
      "id": 14
    }
  ],
  "images": [
    {
      "src": "http://demo.woothemes.com/woocommerce/wp-content/uploads/sites/56/2013/06/T_2_front.jpg",
      "position": 0
    },
    {
      "src": "http://demo.woothemes.com/woocommerce/wp-content/uploads/sites/56/2013/06/T_2_back.jpg",
      "position": 1
    }
  ]
}'
 

It's just a matter of reading the docs.

Writing an store by yourself sounds like reinventing the wheel: there are plenty of options, most of them open software. The taks of building one by yourself is really big, and not sure if we will be able to get a ROI that justifies that.

Regards