Woocommerce REST API tutorial with Crocoblock JetEngine | Elementor

You might came across several scenarios in which you need to fetch certain information from a #woocommerce website using REST API be it customer data, orders details or products information.
In today's video we will be discussion on how to display these information using #Crocoblock #JetEngine without writing a single line of code.
00:00:00 Introduction
00:00:40 Enable REST API in woocommerce
00:02:00 Setup REST API endpoints using JetEngine
00:04:40 Query Builder to fetch API records
00:05:55 Create Table in Table Builder
00:08:24 Display information in page
00:09:50 Change Limit of API records
00:10:40 Add Pagination to Table Builder
Woocommerce REST API Documentation
woocommerce.com/document/wooc...
woocommerce.github.io/woocomm...
Add Datable to JetEngine Dynamic Table
gist.github.com/moxet/7e27a35...
Download #Elementor:
elementor.com/?ref=16401
Download #Crocoblock:
crocoblock.com/?ref=4088
Need to build dynamic websites?
softemblems.com
Follow me on Social Media
Facebook: / mxtchamkani
Instagram: / moxet
Twitter : / sokaniwaal
Track: Peruvian Woods - Dave Osorio [Audio Library Release]
Music provided by Audio Library Plus
Watch: • Peruvian Woods - Dave Osorio | Free B...
Free Download / Stream: alplus.io/peruvian-woods

[@rookiesmarts]

Amazing stuff Bro... I had a question if you could help it would be great... I need to expose a "custom sql joined query CCT data" as a REST API to other website in which there will be a "auth_code" query parameter (which will use used with CUSTOM AUTH table join). Any leads on how I can do this? Thanks in advance.

[@MoxetKhanPK]

CCT has REST API endpoints which you can use to access CCT data from outside without join SQL. If you need filteration it does provide that. For auth you can use wordpress user application password.

[@rookiesmarts]

@@MoxetKhanPK ​ yes thats true CCT has its a REST API, but I plan to make a "custom sql joined data query" which will join 3 CCT.. similar to a stored procedure data output.. one table which will be joined will be a cct_AUTH table which will return data only if the @auth_code_param query variable param matches... Have you encountered such use cases?

[@rookiesmarts]

​@@MoxetKhanPK Ex. SELECT FROM tabl1, table2, authtable where tabl1.col1 = tabl2.col2 and authtable.codecolulm = auth_code_queryparamater

[@MoxetKhanPK]

@@rookiesmarts you want to make a listing over these queries? It yes it is possible.

[@rookiesmarts]

@@MoxetKhanPK Currently in Jetengine there is only REST API url for one CCT table is possible.. Hope I am able to explain it correctly but I am trying to convert this custom query output as a REST API url with auth_code query parameter as its basis for custom authentication. this will take the use case of REST API to the next level and may also eliminate the application passwords use. Any idea or video if could make will be of great help. Thanks. Have a nice day. Cheers

[@affiafridi]

Thanks for the great tut Guru!

[@ahmedd.masoud6809]

Amazing Abdul Moxet, keep going bro,

[@Elsteck]

Magic! Thank you

[@mohmdalazari5746]

You are great bro. more videos about rest api and woocommerce. Thanke you🙏

[@taufiksmp6816]

how to make cct single page without using REST API ? it is possible ? i try to make single page with cct and use feature "has a single page". but it's limited, and I only can add post title and content. i need to show dynamic table in every single page

[@kaisertushar7554]

Thanks for the awesome tutorial. This is really informative. One question, if we want to paginate in REST API, how we can do it (like sending page number and limit)? Like in the example, you call 100 records at once and then use datatable to split data into 10 records per page. But can we pass something in REST API so that, REST API can understand how much data to send as a response and we can show it through Jet Dynamic table with pagination support? I couldn't find anything regarding pagination with REST API when we use Jet Engine tabe (with query builder).

[@jr.digital]

Hello! Great video, thank you for the explanation. Can we use the JetEngine to programmatically create a product in WooCommerce from another website (with the PUT)? Thanks

[@momohezekieltrump6835]

Thanks for the tutorial MK. I don't know. But i'm learning this stuff. Can I use this idea possibly for posts and not products?

[@MoxetKhanPK]

REST API works with CPT and Products both, you can try on anything.

[@hart_studio]

Thanks Khan. I'm used this tutorial to display Woocommerce orders, but I would like to show in my listing just orders for the logged in user. As I can see the filter inside the Query builder is not working right? Can you suggest me another solution to do it?

[@MoxetKhanPK]

Yes filteration is not working as of now, we need to wait untill is fixed.

[@zakariaboulouarde4591]

Thank you so much for this tutorial, wanna just ask if we can add an image from a url to the table? Thank you

[@MoxetKhanPK]

Yes you can show it through images, "images": [ { "id": 795, "date_created": "2017-03-23T14:03:08", "date_created_gmt": "2017-03-23T20:03:08", "date_modified": "2017-03-23T14:03:08", "date_modified_gmt": "2017-03-23T20:03:08", "src": "example.com/wp-content/uploads/2017/03/T_4_front-11.jpg", "name": "", "alt": "" },

[@toni_jaay]

With the read/write access, how would you "write" (I assume it means to update) the information?

[@MoxetKhanPK]

You need to use Jetform builder with POST action to target certain endpoints & send exactly the same information they require.

[@MoxetKhanPK]

If you want to show images from the REST API request of woocommerce, please follow these settings. imgur.com/a/as1DqHn

[@ufocatchers]

Hi , May you tell me how to setting the API image clickable and link to Product ?

[@user-ez5xj9hq5b]

It should be ---> ?consumer_key=xxx&consumer_secret=xxx and not ?consumer_key=xxx&secret_key=xxx. For people who are facing the 400 errors.

[@mohsinshakeel6482]

Thanks for the great Tutorial. Can We Filter these records using jetsmartfilters?

[@MoxetKhanPK]

No filteration as of now

[@mohsinshakeel6482]

@@MoxetKhanPK Thankyou

[@karl-knoop]

Great tutorial! Is it also possible to integrate products into wordpress via the Shopify REST API?

[@MoxetKhanPK]

Yes why not!

[@karl-knoop]

@@MoxetKhanPK Thanks, for your reply Moxet. A tutorial with Shopify would be nice because Shopify is so much faster than Woocommerce but it´s pain in the ass to customize. A combination of Wordpress und Shopify sounds perfect.

[@MoxetKhanPK]

@@karl-knoop The integration you intend to build is not recommended, only for design you have to bring your data from shopify to wp? there are 100 of back & forth functions which you need to apply. My guess was to display the data & reports in your wp from Shopify which might bring some benifits.

[@mw1076]

Can I use API on my localhost? I am working with xampp.

[@MoxetKhanPK]

Yes you can use, you must have internet

[@mw1076]

@@MoxetKhanPK I am working with WordPress. And in WordPress its url in localhost is http, but API is actually sending in https. Therefore it generates an error. How can I overcome such issue?