Export Via Command line

  • Posts: 77
  • Thank you received: 3
11 years 3 months ago #117966

Is it possible to simply export via a command line ?

Please Log in or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
11 years 3 months ago #118003

Hi,

What do you mean by "a command line" ?
Executing a command line in ssh to export ?

To export you can have many options thanks to the mass acitons, create a massaction of the desired date, for example, product and select a trigger which will say when the action must start, and in the actions select "exportCsv".

Please Log in or Create an account to join the conversation.

  • Posts: 77
  • Thank you received: 3
11 years 3 months ago #118116

Yes I mean cml
Or executing in ssh.

What am getting at is creating a cron job to Auto export all products as a means of BU

Please Log in or Create an account to join the conversation.

  • Posts: 77
  • Thank you received: 3
11 years 3 months ago #118117

While talking Import / export
I have another Q.
This seems odd, maybe you can explain.
ALL our products have options. The main products does NOT have price but relies on the options for its pricing.

We now wanted to implement product relations, I have an import file with the product code; product ID; and the related product field.
Upon importing, the system wipes out ALL the options for each main product.

Any Ideas ?

Thanks as always..

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
11 years 3 months ago #118131

If you configure a mass action to export products based on a hourly cron trigger, and if you configured your cron task in the configuration, each hour, the system will generate a CSV automatically.
Now you could potentially manually trigger that cron URL from the command line.
But that's all I can propose from the command line for exports.

Regarding the import: Import is for inserting the initial data, not updating it. So yes, it replaces all the data and if you don't specify the options in the CSV, it will wipe them.

If you want to actually update products information, you should do it via the mass action import filter (the CSV should be the same).

Please Log in or Create an account to join the conversation.

  • Posts: 77
  • Thank you received: 3
11 years 3 months ago #118136

That`s not possible, as each product has a different value.

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
11 years 3 months ago #118337

I don't see why it wouldn't be possible ?
The import of CSV of the mass action system allows you to update the values of all the products at once with the data from the CSV without overwriting the other data. Exactly what you want.

Please Log in or Create an account to join the conversation.

  • Posts: 77
  • Thank you received: 3
11 years 3 months ago #118348

Oh Geez Nicolas, I`m sorry
I didn`t realize what you meant.
You`re saying to upload a csv via the mass actions as opposed to the regular Import.

I thought you meant to use the update filter...
Gotchya...

Please Log in or Create an account to join the conversation.

  • Posts: 77
  • Thank you received: 3
11 years 3 months ago #118430

Using the mass actions.
In this case trying to update the price for ALL products within a certain category.
It is updating the retail price, (left lower region on product edit page)as opposed to the
Prices field (Right mid region on product edit page)
I do not see another priceS value field to update.
What field is it that I need to update to change the Right mid region PRICES value ?

I also have a nodd thing, while after doing filters.
shows there are 602 products.
Upon exporting based on that, I end up with 501 products..
Is there a limit to how may can be exported ?

Also the entire Mas actions, while it says AND
it seems to me to be doing OR
So if you do a filter for one thing,
than add another. It should narrow it down even more.
BUT on the second filter my number increases the results rather than filtering even more.

Whats with that ?

Attachments:
Last edit: 11 years 3 months ago by colpc. Reason: added observation

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
11 years 3 months ago #118460

mmm. I don't see how that's possible.
Can you verify that you didn't select the "price_msrp" field and not the "price_value" field for your action ?

The number tells you how many elements apply to each filter but if you execute the mass action, all the filters apply to them and thus it is an "AND".

Please Log in or Create an account to join the conversation.

  • Posts: 77
  • Thank you received: 3
11 years 3 months ago #118470

Yes I can confirm. I did a few times

Here is a quick example. I used Published as another filter.
There are about 10 UN published items in entire store.

Based on filter 1 you can see we have 601 products in this particular category

So of those 601, lets say I wanted to filter for published or not ( just for testing for you)

Why would this number be greater than the 601 ?

Attachments:
Last edit: 11 years 3 months ago by colpc.

Please Log in or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
11 years 3 months ago #118490

Hi,

It's normal that this value is greater than the previous one, the counter are independent.
They display the number for their filter and not based on the global filtering.

When configuring the action, you have to select "Update the values" then "price_value" in the "Price" part of the dropdown.
I just tried on my end and it's updating the product price value correctly.

Please Log in or Create an account to join the conversation.

  • Posts: 77
  • Thank you received: 3
11 years 3 months ago #118573

OK
I just have been doing lists and data for some time, and never saw filter be independent.
In order to see what changes are going to be made, it`s normal for this number to be narrowed down.

But whatever, maybe it could be considered for updates ?

Either way .. thank you

Please Log in or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
11 years 3 months ago #118629

We will see, because for each counter a request is made.
To have a general count, we need to merge all the different requests made, and that's not as easy as it seem.
Besides the requests are made in many tables at time.

I have noted that, we will discuss about that.

Please Log in or Create an account to join the conversation.

  • Posts: 77
  • Thank you received: 3
11 years 3 months ago #118717

Fair enough. I understand. Just thought worth mentioning.
Thanks for your time.

Please Log in or Create an account to join the conversation.

Time to create page: 0.092 seconds
Powered by Kunena Forum