Pre-Sort Data in variable product short description

There’s nothing in this support request to work with; no link to see the problem, no clear description of the issue, just “it used to work, then I changed something, now it doesn’t work!” So, obviously, the problem you’re having is related to the change you made. Double check yourself.

ok these are the details

Setting that I didn’t change is in Settings -> Inline Google Spreadsheet Viewer
At the text field of DataTables defaults object I have this code:

{
    "searching": false,
    "paging": false,
    "order": [
        [
            2,
            "asc"
        ]
    ]
}

I’m loading the google sheet table in the short description of my product in woocommerce. When I use this code for a simple product, this code works as intended, sorting the 3rd column of my table when it is loading. Example: https://pricehero.com.my/product/test/

later I decided to group similar products together and put them as variable products instead. Since I wanted different table to load at the short description when a different variable product is selected by my visitor, instead of inserting the [gdoc] shortcode at the short description of the product, I inserted the code at the “description” field for each variation. Refer to this screenshot: https://imgur.com/a/GvRx4

After the change, it worked as intended, displaying the correct table when visitor has chosen a different option. But the table no longer sort when loading as the previous simple product case.

You can refer to this example: https://pricehero.com.my/product/similac-gain-kid-step-4/

I’ve double checked, the DataTables defaults object remains unchanged. the [gdoc] shortcode I’ve used for both case is the same: [gdoc key=”1USfj7j6GE_rMXnUyddi_RvQCQUe8nYtozzTE8V00X0Q” gid=”1012573332″ ]

I hope my explanation is clear enough so that you can shed some light to me on how to solve this.

Thank you

Hi @meitar, is the explanation detailed enough? Sorry for bothering you

Two things:

1. The defaults object applies to all this plugin’s tables across your whole site. If you’re just trying to sort one table, then you should use a shortcode attribute (maybe datatables_order in your case) on the one shortcode invocation itself, not the plugin’s site-wide Settings screen.
2. If I were you, I wouldn’t use this plugin at all for what you’re trying to do. Unless you have some reason to put your product detail data in a Google Spreadsheet and not in WooCommerce (which is designed to hold product detail data), you’re making a lot of unnecessary work for yourself. Why not use WooCommerce the way it was intended, and this plugin the way it was intended, instead of fighting against both tools?