• Resolved pietrobar

    (@pietrobar)


    Good evening,
    I’m at the beginning of my experience with wordpress and woocommerce and I have a question ..
    I have a csv file with the “Technical Sheet” column and for each product in the csv file the “Technical Sheet” column contains a static html page of the supplier where it is not possible to perform Web Scraping and not even from Google Sheet or PQ it is possible to extract the data and then import them ..
    Is it possible in some way to import the url of the Technical Sheets (for example https://www.XXXXXXXX.com/portal/product/detail.do?partnumber=JGCH8) to associate them with woocommerce products?
    I can’t find the button in the topic where to insert the print screens I made, I can’t attach the Supplier’s link because to access the content of the link because the Static Public IPs must be entered in the White List.
    In practice, when you click on the link, the web page opens in full screen with tot images of the products above on the left, the description on the right, and underneath Three Technical Sheets made in the table.
    Initially I thought you could ungroup the web page and convert it to csv with:
    -A Column for images
    -A Column with all the Description
    -One Column with the First Technical Sheet in the table and two other Columns with the remaining Technical Sheets
    But then the Supplier told me that the data cannot be extrapolated and that they are static html pages and must be published as they are.
    Now I have the problem that I do not know how to import the pages with the technical data sheets in the site and even if I somehow managed to do it I do not know what layout could come out because I, besides the link with the Technical Sheets, need to also show all the other fields, such as the code, the price, etc.
    A thousand thanks`

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support lionel.a11n

    (@lioneldaniel)

    Hello @pietrobar,

    It is unfortunate that the data is embedded in HTML pages and can’t be easily adapted to your CSV file. The built-in CSV product importer only works with CSV files, and there is not way to import such pages directly into WooCommerce with the built-in importer. In case it helps, click here for the full import/export CSV schema.

    Since you already ruled out using a web scraping method or other pre-existing automations, you are left with either getting a developer who could help you convert those HTML pages into CSV data, or filling out the fields in your CSV by hand.

    Regarding attaching screenshots, you can use any website which lets you upload images and then link those here to share them.

    I hope that clarifies that there isn’t an additional tool to convert arbitrary HTML data into the CSV format needed for the importer. Custom scripts and elbow grease are going to be your main options here, so I’m marking this as resolved. Feel free to start a new topic if you have any more questions.

    Cheers!

    Thread Starter pietrobar

    (@pietrobar)

    O, thanks a lot ^^

    We’re happy to help!

    If you have further questions, feel free to create a new thread.

    Regards

    Thread Starter pietrobar

    (@pietrobar)

    thank you very much, I have opened a topic regarding the lines of the Additional Information table
    [WooCommerce] Help Lines Table Additional Information Sheet

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Help Import Link’ is closed to new replies.