Link Wordpress Product data table to power query

G

gazmoz17

Board Regular
Joined
Sep 18, 2020
Messages
158
Office Version
  1. 365
Platform
  1. Windows
Hi,

I'm new to power query and we stumble along with our wordpress website.

Wish to create a connection so that my Query is showing live product sales price from web. So only require the "SKU" & "Regular Sales price" from wordpress.

Then want to compare to existing Query from our software.....ultimately so cn track what prods are and arent on the web. Also obvs for any diff in price between web and software.

Many Thanks
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
You must log in or register to reply here.

Similar threads

G
  • Question Question
Link Excel Power Query to worpress website (ODBC ect)
Replies
2
Views
426
gazmoz17
G
jlhoover3
  • Solved
Power Query - Filter table column based on cell value
Replies
3
Views
2K
alansidman
A
K
  • Solved
Can you add data to a Power Query ?
2
Replies
11
Views
890
JEC
JEC
G
  • Solved
Power Query: Last instance a customer purchased a Product
Replies
3
Views
387
gazmoz17
G
G
  • Question Question
Power Query 3 way lookup
Replies
0
Views
324
gazmoz17
G

Forum statistics

Threads
1,223,956
Messages
6,175,607
Members
452,660
Latest member
Zatman

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top